Forum Discussion
stack bar chart - percentile line
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
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
4 Replies
Hi egutierre245
will be visual "Line and stacked column chart" good for you?
Just create a calculated column like
Percentile = 0,5do not hesitate to give a kudo to useful posts and mark solutions as solution
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
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
