Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
sorry, can you please share a screenshot the steps you did to create the calculation group? Thank you 🙂
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks so much!
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |