cancel
Showing results 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

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%)

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

Below is the sample data:

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:

1 ACCEPTED SOLUTION
Community Champion

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)

Proud to be a Super User!

4 REPLIES 4
Community Champion

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

Proud to be a Super User!

Anonymous
Not applicable

Sure.

Below is the sample data:

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:

Community Champion

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)

Proud to be a Super User!

Anonymous
Not applicable

Yes this worked, thank you very much!

Announcements

#### 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.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors