Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rules for graph formatting not applied correctely

Hi all

 

I am applying a formatting rule to a visual (a combined bar and line chart) for which the bars have a conditional formatting: The bars should be in blue for values below or equal to a certain threshold and in red for values above it. However the threshold is not applied correctely. Precicely, my threshold is at 16.26%, however two of the bars have the wrong color even though they are above this value (17.26, 19.17%). Only the bar having a value of 21.22% appears in the correct color red. For all values above it also works perfetely fine.

 

No idea what is going wrong!!

Any idea?

 

Thanks 🙂

Need Help

8 Replies

  • pi_eye's avatar
    pi_eye
    Resolver IV
    3 years ago

    Hi Rebreg, can you share your DAX in each instance?

     

    If you hover over the bars in the chart, what values do they give?

     

    Pi

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      When i hover over the bars, thats when I see that the formatting is not applied correctly. Then it shows the values i mentioned above (17.26, 19.17%). And even though they should appear in red, they appear in blue.

      The rule doesn't need any DAX, i put it here:

      The measure I am visualizing as bars has the formula 

       

       

      Data for bars = 
CALCULATE(
    COUNTROWS('datatable'),
    'datatable'[color] = "Red"
)/
COUNTROWS('datatable')

       

       

       

      I am plotting it over another attribute of the data table (a customer key) on the x-axis.

       

      Thanks for your help!

      • pi_eye's avatar
        pi_eye
        Resolver IV
        3 years ago

        hi Rebreg

         

        My german is not good, but I've noticed you've got different units for the tolerances. This could be confusing it - maybe this is the issue?

        Prozent vs zahl

         

         

        Pi