Forum Discussion

HENRIQSI's avatar
HENRIQSI
Frequent Visitor
8 years ago
Solved

Column + line chart

Hello,

I have a chart with Columns (Month results) + lines (month goals).

Someone knows how to put a color conditional for de columns when its up or down the goal line? Like, green for values upper than goals, and red for down?

  • HENRIQSI's avatar
    HENRIQSI
    8 years ago

    Problem solved!
    Just for information, I created  2 new measures, conditioned (Productive good = IF([Productive3]>[Goal3];[Produtictive3];0) and (Productive bad = IF([Productive3]<[Goal3];[Produtictive3];0). 


    Ps: Indicators MUST be in Measures with Sum function

     

    Ex. [Productive3] = DIVIDE ([Production3];[Worked hours3];0)]

         [Production 3] = SUM (Plan1[Production]);

         [Worked hours3] = SUM (Plan1[Worked hours])

         [Goal3] = SUM (Plan1[Goal])

11 Replies

  • HENRIQSI's avatar
    HENRIQSI
    Frequent Visitor
    8 years ago

    Hello,

     

    Well I have a Collum (month values) + Line (month goals) chart.

    Someone knows how to put a conditional to change the collor of the columns of my chart, if it up (green) or down (red) the line?

    Thx.

     

     

  • pxg08680's avatar
    pxg08680
    Resolver III
    8 years ago

    HENRIQSI

    First thing is , is your goal line fixed..?

     If yes, use the same column Productive... and put it in the colorSaturation field and go to data color section. Select the diverging option and put the center value as you goal line value.

     

    Hope this solves your problem.

    • HENRIQSI's avatar
      HENRIQSI
      Frequent Visitor
      8 years ago

      Unfortunately my goal line isn't fixed...

      And in the Column + line chart option there is no ColorSaturation option =/

  • HENRIQSI's avatar
    HENRIQSI
    Frequent Visitor
    8 years ago

    Problem solved!
    Just for information, I created  2 new measures, conditioned (Productive good = IF([Productive3]>[Goal3];[Produtictive3];0) and (Productive bad = IF([Productive3]<[Goal3];[Produtictive3];0). 


    Ps: Indicators MUST be in Measures with Sum function

     

    Ex. [Productive3] = DIVIDE ([Production3];[Worked hours3];0)]

         [Production 3] = SUM (Plan1[Production]);

         [Worked hours3] = SUM (Plan1[Worked hours])

         [Goal3] = SUM (Plan1[Goal])

    • lucasborges's avatar
      lucasborges
      New Member
      8 years ago

      I did it and it works but it shows like this:

       

       

      How can I make the chart show only a single bar, the one with actual values?

    • lucasborges's avatar
      lucasborges
      New Member
      8 years ago

      I did it and it works but it shows like this:

       

       

      How can I make the chart show only a single bar, the one with actual values?

      • HENRIQSI's avatar
        HENRIQSI
        Frequent Visitor
        8 years ago

        Hello Lucas,

        probably is the type of chart that you choose.

        Look like you selected Line and clustered column chart, when I choose Line and Stacked Column chart.

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      i have that same issue. I couldn't understand how did you solve that. Could you please share pbix if you have ? or tell again ?
      Thanks.

      • HENRIQSI's avatar
        HENRIQSI
        Frequent Visitor
        7 years ago

        I just created 2 new measures. The first is for the results bigger than goal, and the second is for results smaller than goal.

        So, instead of plot the result measure, plot the 2 new measures and the goal, and define a color for each measures (in my case, green for good and red for bad).