Forum Discussion
100% Stacked Column and line chart
Hi,
I know there is already a thread here with the same title which I've tried to follow but can make it work. I think because I have multiple values to display.
What I'm trying to create is a 100% stacked column and line chart. There are four time bands I would like to display as a 100% stacked column chart, with the percentage resolved within SLA as a line on top. I've created the below column to separate the time bands but I can't work out how to create a % measure from it as was suggested in the previous post. 100% STACKED column and line chart
Thanks in advance!
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- amitchandak
Super User
Anonymous , R u looking for this option
https://radacad.com/showing-the-total-value-in-stacked-column-chart-in-power-bi
or
https://www.tutorialgateway.org/create-100-stacked-bar-chart-in-power-bi/
- AnonymousNot applicable
Hi Amit!
Thank you for looking into this! I'm trying to create a chart like this with my data:
So the existing 4 time bands I showed in my original post would be the 100% stacked columns, and I still need to add a fifth value for an SLA pass or fail percentage (I already know how to do this bit so didn't include it in my question).
- v-lionel-msft
Community Support
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.