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:
- How to display actual level three data in report
- Is it possible to apply color code conditional formating for Tree map
visualization, is yes then how to apply please let me know.