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.
I have the below matrix but I only want the 2021 ANZ column to appear once, to the right of the 2021 charge count column.
Is this possible?
Solved! Go to Solution.
Hi @Anonymous
You can represent the 2021Anz column as a total column.
You can try measure as:
measure =
IF(
HASONEFILTER('Table'[year]),
[Charge count],
[2021 Anz]
)
Modify the name of column subtotals:
Here is the output:
The pbix is attached, please check.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can represent the 2021Anz column as a total column.
You can try measure as:
measure =
IF(
HASONEFILTER('Table'[year]),
[Charge count],
[2021 Anz]
)
Modify the name of column subtotals:
Here is the output:
The pbix is attached, please check.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Seem like you need a Hybrid Table
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/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |