Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would like to incorporate the visual below into a Matrix. This visual shows taxes paid by different groups. Within the matrix I would like to place location in the column section of the matrix. The matrix columns would show “World”, “U.S” and “International”. The challenge is, “World" is not an actual column in my data set. The world column is just the combination of the U.S and International columns added together. Is there a way to create measure that allows me to add a "World" column to the matrix at the same hierarchical level as U.S and international?
Solved! Go to Solution.
@dw700d , If US and international are rows values in column, then World is like grand total, You will get that as Grand total in matrix.
Otherwise all of them need to me measures
OR consider Hybrid table workarounds
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
Hi @dw700d ,
Have you tried using 'Calculation Groups'?
You can define a calculation group which will have 3 values U.S., World and International.
In calculation for the US and International, you can provide a filter in the measure and for World, since is it just the sum of US and International you don't need to provide the filters.
Hope this helps.
Thank you,
Vishesh Jain
Proud to be a Super User!
@dw700d , If US and international are rows values in column, then World is like grand total, You will get that as Grand total in matrix.
Otherwise all of them need to me measures
OR consider Hybrid table workarounds
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |