Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi experts,
I am trying to display this:
But, like:
So far, I :
Created a matrix with:
-Rows: MemberID
-Columns: Metric Name, Completed Date
-Value: Units Passed
My problem now is that:
For Columns: Metric Name, Completed Date
I get either by month or by metric name, and I need both at the same time as my screenshot above...
I was hoping to see some sort of 'combine' option here but there isn't.
Solved! Go to Solution.
You should be able to complete this by using the drill down by column and moving to the next complete step in the heirarchy.
Instructions can be found here: https://docs.microsoft.com/en-us/power-bi/desktop-matrix-visual
Proud to be a Super User!
You should be able to complete this by using the drill down by column and moving to the next complete step in the heirarchy.
Instructions can be found here: https://docs.microsoft.com/en-us/power-bi/desktop-matrix-visual
Proud to be a Super User!
Even though I set to show all months:
In the results for example, I see only ‘march’ and ‘april’, why is that?
HI @maca128,
When you use matrix visual, it will auto hide whole row/column which only contains blank value or not real existed in table.
For this scenario, it is impossible to expand these non existing records to matrix.
You need to create a calculate table with the original records and expand the blank records, then you can use the new table to create the matrix visuals as expected.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |