100% Stacked Column and line chart

[Anonymous]

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 

Resolve Time Bands = IF(PowerBI_SERVICE_DB[Resolve_time_mins]<240,"0-4hrs",

IF(AND(PowerBI_SERVICE_DB[Resolve_time_mins]>=240,PowerBI_SERVICE_DB[Resolve_time_mins]<480),"4-8hrs",

IF(AND(PowerBI_SERVICE_DB[Resolve_time_mins]>=480,PowerBI_SERVICE_DB[Resolve_time_mins]<960),"8-16hrs",

IF(PowerBI_SERVICE_DB[Resolve_time_mins]>960,">16hrs"))))

This is the result when put on a stacked column chart:

I need it to return 100% stacked so I can put a line over the top for the SLA measure, as if I was using a 100% stacked column chart

Thanks in advance!

Kind Regards,

[amitchandak]

@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/

[Anonymous]

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

Hi @Anonymous ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerlearner321]

Hi, 

I'm also facing same issue and your solution worked for me but when I use country Region in slicer to filter then the column chart is not 100%. I tried multiple workarounds but nothings seems working. 

could you please suggest if theres any work around?

[Anonymous]

This solution worked for me but my slicers are not filtering the 100% stacked columns correctly?  The numbers change but they don't display the correct %'s?

I need to show 1 chart with 100% stacked column bar chart with lines so I'm using the "Line and Stacked Column" Chart Type but need to show the column bars as 100% stacked.  My x axis has the waves (or months) and my data is weighted so I'm referencing WGT to get the weighted %'s.

This is what I'm using:

Q13COLUMN_100P =

VAR x = cALCULATE(SUM(Clean_PBI_LABELS[wgt]),ALLEXCEPT(Clean_PBI_LABELS,Clean_PBI_LABELS[Q13COLUMNS_NEW],Clean_PBI_LABELS[WAVE_NEW]))

VAR y = CALCULATE(SUM(Clean_PBI_LABELS[wgt]),ALLEXCEPT(Clean_PBI_LABELS,Clean_PBI_LABELS[WAVE_NEW]))

RETURN

DIVIDE(x,y)

Does anyone know why?

The %'s are okay until I try using slicers.  The line graph %'s are also showing the correct %'s using slicers.

Thanks!

[Anonymous]

Thanks so much! This helped me create my chart!