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

[MartinSm]

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

[v-priyankata]

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 · Accepted solution]

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,

[MartinSm]

yes, thank you a lot, Martin