Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a chart with a hierarchy where the first column (month) includes 2 sub categories and their corresponding occurrence. I somehow need to move it to BI, i don't want to have the same month typed for both sub categories. When i simply move it to Power BI, i get "null" in the blank cells as shown below
Solved! Go to Solution.
Hi @Ogudkov ,
After loading into Power BI desktop, locate to Query Editor mode. Right click [Date] field, choose "Fill->Down".
Apply changes. In report view mode, insert a Matrix visual to display data as below. Drill down to "Date-Color" level and turn off "Stepped layout" option.
Best regards,
Yuliana Gu
Hi @Ogudkov ,
After loading into Power BI desktop, locate to Query Editor mode. Right click [Date] field, choose "Fill->Down".
Apply changes. In report view mode, insert a Matrix visual to display data as below. Drill down to "Date-Color" level and turn off "Stepped layout" option.
Best regards,
Yuliana Gu
This is exactly what i was looking for, thank you so much!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |