Solved: Crosstab format for Matrix

ashrat001 · ‎03-15-2021

Hi Experts,

I have a few measures, Month dimention and using Matrix to display them. Following is the current format in which these are being display.

And following is the format I need to have in my dashboard. How can I achieve this. Thanks!

amitchandak · ‎03-15-2021

@ashrat001 , if these are measures. You can use "Show on Row" property in matrix visual. Which will move values/measure at row

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎03-15-2021

@ashrat001 , if these are measures. You can use "Show on Row" property in matrix visual. Which will move values/measure at row

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Crosstab format for Matrix

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024