Matrix Visulisation

[watje255_ju]

Hi, 

I would like to have 3 measures  shown in quarters individually, but not side by side under each quarter, is there a way i can do this?

In the actual dataset, there are some customers that have 0 values, therefore if I have three seperate matrixs, the rows get misalinged as customers with no sales in that quarter get excluded etc.

Example photo or desired result below, PBIX file link Matrix test.pbix thanks in advance! 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but one of ways is to create Calculation Group.
Please check the below picture and the attached pbix file.

Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn

[watje255_ju]

sorry, can you please share a screenshot the steps you did to create the calculation group? Thank you 🙂

[Jihwan_Kim · Accepted solution]

[watje255_ju]

Thanks so much!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but one of ways is to create Calculation Group.
Please check the below picture and the attached pbix file.

Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn