stack bar chart - percentile line

[egutierre245]

I have a very simple stacked bar chart with gender distribution across several groups. I need to show a line at the 50% mark. PowerBI will do this when the graph is small, but as soon as I make the graph wider PowerBI will change the lines to every 20%. 

How can I keep this line at the 50% mark fixed, regardless of how wide the graph is? 

Many thanks in advance, 

Esther

[az38]

Hi @egutierre245 

will be visual "Line and stacked column chart" good for you?

Just create a calculated column like

Percentile = 0,5

do not hesitate to give a kudo to useful posts and mark solutions as solution

[egutierre245]

Thanks ! 

Actually, I need it to be a 100% stack bar chart with the bars running horizontally and the 50% mark line running vertically. Just like the image below but only one line at the 50% mark instead of every 20%. 

Many thanks in advance for any ideas!

Esther

[az38 · Accepted solution]

@egutierre245 

you can use this visual from marketplace https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381805

there is an option "Constant line"

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[egutierre245]

This worked a treat, thank you so much!! 🙂