Measures as Matrix Rows?

[Anonymous]

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

[amitchandak]

@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/

[mahoneypat · Accepted 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

[Anonymous]

Thanks for the quick response - that's exactly what I was after!