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.