Power BI Report with tree map visualization

May 13 2021 10:34 AM

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:

  1. How to display actual level three data in report
  2. Is it possible to apply color code conditional formating for Tree map visualization, is yes then how to apply please let me know.