Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hello, I am tracking some donation data and found some measures to give me the data I want to see in a Matrix visual, but I can't figure out how to display specific records in a column chart. To explain, the donation categories are in 3 different Groups - A, B and C. I was able to show, with the Matrix, the data as the following:
I want to display in a column chart Group B and Group C only. So, if I create a column chart with all 3 Groups I get this,
But I want this:
If, I hide Group A, I get this:
How do I get the chart to display only the two groups correctly? Thank you.
Solved! Go to Solution.
Hello, you will need a measure to achieve this. Heres the DAX but you will need to massage it to your table name, field name etc:
Thank you, that was very helpful, but how do I show the data labels as %? Is there a format within the Measure that should be added?
I found it! In the Measure Tools. All good now. Thanks again!
Hello, you will need a measure to achieve this. Heres the DAX but you will need to massage it to your table name, field name etc:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
88 | |
86 | |
68 | |
51 | |
32 |
User | Count |
---|---|
126 | |
112 | |
72 | |
64 | |
46 |