Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello;
i have created a Matrix that includes 8 columns. Each of these columns are measures based on Actual Month or YTD.
Now i would like to create some kind of Column above the measures to show Actual Month and YTD as in the image below.
Is there any opportunity to create maybe some kind of measure groups and use them in the matrix?
Thanks in advance
Hi @Krexx ,
To my knowledge, Matrix does not support displaying different columns/measures under Row fields.
You could create two matrix visuals respectively and then group these two visuals to get the expected output.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@MattAllington Hello Matt thanks for your response. It helped a lot. I have still difficulties.
If i have 3 Measures for "Month" and 2 Measures for "YTD" then it duplicates the single measure that is only displayed in "Month" with blank values in "YTD". Do you have any idea why?
Read my other article here. I should have posted this one the first time - sorry. https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/
You can do this with disconnected tables similar to this article. https://exceleratorbi.com.au/waterfall-charts-using-measures-power-bi/
once you have the table, you can add the column to your matrix
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |