Forum Discussion
Not sure where to start
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!!
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#M187480
1 Reply
vicky_Super User
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#M187480