Is it possible in a Matrix to show 2 measures next to eachother by Year? (screenshot)

[svenvu]

Hi

Is there a way to show all values of one measure by Year, and next to it, show all the values of a second measure by Year?

In Excel Pivottables you can easily do that but I'm not sure this is possible in Power BI? I think you need to create 12 measures and add measures every year?

Friendly greets

[mahoneypat]

Not sure you can make the same easily in Power BI.  One approach might be two make two identical matrix visuals with the two measures and then overlap the first over the row labels on the second (using the selection pane on the View tab to get the display order right).

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[amitchandak · Accepted solution]

@svenvu ,I doubt possible easily. No build in option. refer

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