March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
203 | |
141 | |
107 | |
73 | |
70 |