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 cert...
Need Help
pi_eye's avatar
pi_eye
Icon for Resolver IV rankResolver 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
    Icon for Resolver IV rankResolver 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Ah I am sorry, I made an example just for this post where I was sloppy. In my plot all the units are the same (%) and the problem still occurs.

      • pi_eye's avatar
        pi_eye
        Icon for Resolver IV rankResolver IV
        3 years ago

        Hi - this is very strange. I was able to recreate the issue locally.

         

        When I set the tolerances as % - the formatting in the chart is wrong:

         

         

         

        However when I change it to Numbers  it starts to work:

         

         

         

        I'm not sure why that is - I can only think it might be some sort of bug? Because the % values are accurate in the bars!

         

        I used the same DAX, almost word for word

         

        Data for bars =
        CALCULATE(
            COUNTROWS('what if'),
            'what if'[Color] = "Red"
        )/
        COUNTROWS('what if')

         

        Pi