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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MartinSm
Regular Visitor

100% stacked chart - set minimum of displayed percentage (not value)

Hi community, can you please help me how to set for "100% stacked chart" if I want to display only its part above 80 percent (so 80-100 percent).

A can see MIN/MAX options in Y-axis / Range, but it seem it does not work for final percentage, but only for data values.

As the data values for different filters differ, I cannot use MIN based on data value, but I need to "filter" to 80-100 percent of stacked graph only, where values of other columns are present, but its ratio is not clearly vissible  (one has 2 percent, other 3 percent etc...)

Hope it is clear and thank you very much for hint.  Martin

 

 

 

1 ACCEPTED SOLUTION
DataNinja777
Super User
Super User

Hi @MartinSm ,

 

Power BI does not allow you to set the visible Y-axis range of a 100% stacked column chart based on the percentage outcome (like 80–100%). The Min and Max settings for the Y-axis only work on the raw data values, not on the final computed percentage of a 100% stacked chart. To work around this limitation, use a regular stacked column chart and manually calculate the percentage of total using a DAX measure. Here's an example:

% of Total = 
DIVIDE(
    [YourValue],
    CALCULATE(SUM([YourValue]), ALLEXCEPT('Table', 'Table'[Category]))
)

Use this % of Total measure in your chart’s Y-axis, instead of the actual values. Then, in the chart’s Y-axis settings, set the Minimum to 0.8 and Maximum to 1. This will effectively display only the portion from 80% to 100%, visually mimicking the desired effect.

 

Best regards,

View solution in original post

3 REPLIES 3
v-priyankata
Community Support
Community Support

Hi @MartinSm 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

DataNinja777
Super User
Super User

Hi @MartinSm ,

 

Power BI does not allow you to set the visible Y-axis range of a 100% stacked column chart based on the percentage outcome (like 80–100%). The Min and Max settings for the Y-axis only work on the raw data values, not on the final computed percentage of a 100% stacked chart. To work around this limitation, use a regular stacked column chart and manually calculate the percentage of total using a DAX measure. Here's an example:

% of Total = 
DIVIDE(
    [YourValue],
    CALCULATE(SUM([YourValue]), ALLEXCEPT('Table', 'Table'[Category]))
)

Use this % of Total measure in your chart’s Y-axis, instead of the actual values. Then, in the chart’s Y-axis settings, set the Minimum to 0.8 and Maximum to 1. This will effectively display only the portion from 80% to 100%, visually mimicking the desired effect.

 

Best regards,

yes, thank you a lot, Martin

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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