Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks so much! This helped me create my chart! 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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!
    • powerlearner321's avatar
      powerlearner321
      New Member
      1 year ago

      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?