We have SharePoint online list with three lookup column ex Country, State and district and having two column with Government office and Private office. Based on this wanted to develop the report in Power BI as per below format
India(Level 1) Maharashtra(Level 2) 2 Mumbai(Level 3) 4 Count 2 represent no of gov office and count 4 represent no of private office
I tried with Tree map visualization but at level three instead of data I am getting count, which I don’t want
Questions: