Arranging Values order in Columns (Matrix visual)

[edayan]

Hi Everyone,

How do I get the following view in PowerBI similar to what I have in Excel?

As you can see in Excel, I can aggregate the actuals together and then the fulfilled %.

In PowerBI I'm not sure how to do that.

PS the result of aligning 3 matrix tables side by side works but is very impractical.

Please your help,

Thanks,

Eyal

In Excel-

In PowerBI-

[edayan]

Amazing. Thanks @amitchandak so I have to do this with tabular editor?

[amitchandak · Accepted solution]

@edayan , if you want to measure on top, you need calculation group

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

others

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

[edayan]

Finally managed this. Is there a way to conditional format each parameter?

[edayan]

@amitchandak thank you but it's not working for some reason. as you can see it's giving me the result for the year not the quarter.... also can shift from bottom to top as I needed.