Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiple stacked column chart

Hi All,

 

I am facing diffculties in creating Multiple stacked column chart  for Weekly and YTD. Is there any workout to acheive like below chart

 

 

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      TomMartens  Is there any other option available in PBI to acheive this kind of reporting.

       

      OR

       

      can i show my YTD bar in different color

       

      • TomMartens's avatar
        TomMartens
        Super User
        6 years ago

        Hey Anonymous ,

         

        you can control the fill color of a column/bar by using conditional formatting.

         

        To change the color of the columns from this:

         to this

        I created this measure:

        Measure 2 = 
var _category = MAX('Dimension Customer'[Category])
var fillColor = IF(_category = "N/A" , "red" , "#808782")
return
fillColor

        What the measure does is this:

        It reads the current value of the column Category by using the MAX(...) function. The column is used as inner axis-label.

        If the current value equals "N/A" then the color "red" should be used, otherwise a hexcode.

         

        I applied the measure for the conditional formatting by changing the data colors option of the chart:

         

         

        Hopefully, this provides what you are looking for.

         

        Regards,

        Tom