Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Opal55
Helper II
Helper II

Column chart display only specific records

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:

Opal55_0-1649008534652.png

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, 

Opal55_1-1649008675401.png

But I want this:

Opal55_2-1649009080325.png

If, I hide Group A, I get this:

Opal55_3-1649009167490.png

How do I get the chart to display only the two groups correctly?  Thank you.

 

 

 

1 ACCEPTED SOLUTION
samdthompson
Memorable Member
Memorable Member

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:

 

% of Group =
DIVIDE(
SUM(Donation[Val]),
CALCULATE(SUM(Donation[Val]),ALL(Donation[Group])),
0)

 

2022-04-04_11-21-21.png

// if this is a solution please mark as such. Kudos always appreciated.

View solution in original post

3 REPLIES 3
Opal55
Helper II
Helper II

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?

Opal55_0-1649083561065.png

 

I found it! In the Measure Tools.  All good now.  Thanks again!

samdthompson
Memorable Member
Memorable Member

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:

 

% of Group =
DIVIDE(
SUM(Donation[Val]),
CALCULATE(SUM(Donation[Val]),ALL(Donation[Group])),
0)

 

2022-04-04_11-21-21.png

// if this is a solution please mark as such. Kudos always appreciated.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.