Solved: Not sure where to start

sbailey151 · ‎08-28-2023

I have a need to build a flexible matrix report and I unfortunately do not know where to start.

Essentially I need to display different types of data in rows inside a single matrix. Below is an example of what I mean when I say that, but effectively I need to be able to showcase many different metrics over time and I need to do it all in a single table/matrix.

I've built a lot of different out of the box reports and visualizations in Power BI, but this one escapes me.

Any help would be greatly appreciated!!

vicky_ · ‎08-28-2023

If you're just looking at out-of-the-box visuals, then the matrix is the closest one.
To get the measures to show horizontally, go to Format Visual > Values > Options > Switch values to rows.

And to get the measures to show at the top, look at the solution here: https://community.fabric.microsoft.com/t5/Desktop/show-grand-totals-top-bottom-of-matrix/m-p/408946#...

View solution in original post

vicky_ · ‎08-28-2023

If you're just looking at out-of-the-box visuals, then the matrix is the closest one.
To get the measures to show horizontally, go to Format Visual > Values > Options > Switch values to rows.

And to get the measures to show at the top, look at the solution here: https://community.fabric.microsoft.com/t5/Desktop/show-grand-totals-top-bottom-of-matrix/m-p/408946#...