cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
foodbox123
Frequent Visitor

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
Super User
Super User

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!




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!




View solution in original post

Yes this worked, thank you very much!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.