Matrix

[Anonymous]

Hi,

I am planning to prepare the below type of matrix. Can anyone guide me.

 

[Anonymous]

Hi @Anonymous ,

For this, you may create a slicer visual , choose its type as Relative Date:

And for your expected outputs, can you please share me with your pbix file after removing sensitive data to help us clarify your scenario?

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , One option is unpivot and create an additional column category.

https://radacad.com/pivot-and-unpivot-with-power-bi

Or use calculation group and independent table as I discussed here

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

or

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795