Forum Discussion
Measures as Matrix Rows?
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
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
3 Replies
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
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/
