Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I've calculated a summary table using a dataset and have generated data that I'd like to visualise via a matrix. As seen in the img link below, the calculated table has four columns - KPI 1, KPI 2, KPI 3 and Date.
I would like a matrix where the Date is a column header, each KPI has it's own row and the matrix values are the corresponding values within the summary table. I've seen this be achieved via unpivoting a standard query but I don't believe this is applicable with a DAX generated table. Furthermore, if I just create a simple matrix with just Date and a single KPI, the data is visualised how I would like (minus the missing row header), but when I add multiple KPIs it merges into the same row.
Power BI Summary Table and Example Problems
Any suggestions?
Cheers,
Ollie
Solved! Go to Solution.
Please check out the Show On Rows feature in the Matrix visual.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Anonymous , this is case for the show on row and date on column and nothing on row(group by)
refer how to do that
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Please check out the Show On Rows feature in the Matrix visual.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for the quick response - that's exactly what I was after!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |