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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Stacked column graph not showing accurate % tooltip when sorted

I have a stacked column graph with a tooltip that shows the % of the value compared to the total. This is created by a measure. In the graph you can see that the proportion of the pink is 0.78 (78%)

powerbi1.png

I also created a new table to order the graph so that the pink portion is on the bottom. However, once it got sorted, the % tooltip now shows 100% instead of 78%. Can anyone assist with this? Thanks

powerbi2.png

 

 

Below is the sample data:

foodbox123_0-1632291472275.png

 

The measure for % calculation for tooltip:

% MEASURE 2 =

DIVIDE(SUM('table1[Assign 1 to each number for count]),

CALCULATE(SUM(‘table1'[Assign 1 to each number for count]),ALL(‘table1’[overalloutcome 2])),0)

 

The table I created to order the graph:

foodbox123_1-1632291472166.png

 

 

1 ACCEPTED SOLUTION

Try update formula

% MEASURE 2 =

DIVIDE(SUM('table1[Assign 1 to each number for count]),

CALCULATE(SUM(‘table1'[Assign 1 to each number for count]),ALL(‘table1’)),0)

 

 

 

 

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
FarhanAhmed
Community Champion
Community Champion

Can you please share the sample data and dax of the measure that you are referencing.







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Anonymous
Not applicable

Sure.

Below is the sample data:

powerbi3.png

The measure for % calculation for tooltip:

% MEASURE 2 =

DIVIDE(SUM('table1[Assign 1 to each number for count]),

CALCULATE(SUM(‘table1'[Assign 1 to each number for count]),ALL(‘table1’[overalloutcome 2])),0)

 

The table I created to order the graph:

powerbi4.png

Try update formula

% MEASURE 2 =

DIVIDE(SUM('table1[Assign 1 to each number for count]),

CALCULATE(SUM(‘table1'[Assign 1 to each number for count]),ALL(‘table1’)),0)

 

 

 

 

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Anonymous
Not applicable

Yes this worked, thank you very much!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.