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.
Hello,
I'm looking for a way to creata a Matrix that would like a bit like this.
In the Columns would be different Month/Dates/Hours.
Each line is a Measure, but how to create Rows ?
I could cretae the Measure for every time-slice but how can I pivot the (up to 50) measures into rows ?
Solved! Go to Solution.
For interested people, this is how I solved it ...
I created a Table holding my 'Report Classes'.
I had my basic values stored in a fact table by report class, and uploaded into PowerBI.
Finally just could cretae a Matrix with 2 Measures on that fact. Works Fine, had to use the Sort By Column to Avoid Alpha sorting (was still on during the screenshot) ....
Hi @Anonymous,
Generally, in a Matrix visualization, fileds dragged into columns represent column group and fields dragged into rows represent row group. It is not allowed to add a measure into row cell, because measure returns result which will be regarded as detailed values displayed in matrix.
So, I'm afraid your requirement cannot be achieved directly. Would you please share some sample data, including data view and sample measures so that I can test whether there existing any workaround for you?
Best regards,
Yuliana Gu
For interested people, this is how I solved it ...
I created a Table holding my 'Report Classes'.
I had my basic values stored in a fact table by report class, and uploaded into PowerBI.
Finally just could cretae a Matrix with 2 Measures on that fact. Works Fine, had to use the Sort By Column to Avoid Alpha sorting (was still on during the screenshot) ....
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |