Forum Discussion

omarluna17's avatar
omarluna17
Frequent Visitor
3 years ago
Solved

Column Grouping in Matrix Visual

Hello all!   I was wondering if the following can be achieved in PowerBI:   I currently have a matrix that looks like this.    As you can see, I had to create a different measure for ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

omarluna17 , You have to try column header grouping in the calculation group or use the dynamic segment

 

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

 

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

omarluna17's avatar
omarluna17
Frequent Visitor
3 years ago

Very informative and helpful video. Thank you for your help!