Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional formating based on a dynamic table

I created a dynamic table to use the option of a conditional formating over a matrix table…. In Excel is so easy (Excel is a crap) but here in PBI I have to do it over every column (which are measur...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

Can you show the desired result about the dynamic table, I'm not sure what you really need.

 

Best Regards

Janey Guo

Anonymous's avatar
Anonymous
Not applicable
5 years ago

v-janeyg-msft Conditional formating needs to be based on max and min (Did you get the idea?)

 

 

 

 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    It may be a little difficult to format based on dynamic.

    You need to create some measures with %M1-%M12 ,then use conditional format.

    Try like this:

    %M1color =
VAR V =
    SUM ( DetalleFacturado[M1] ) / SUM ( DetalleFacturado[ImporteLinea] )
RETURN
    IF (
        v <> BLANK (),
        IF ( V < 'MAX-MIN'[MAX] && V > 'MAX-MIN'[MIN], "Green", "Red" )
    )

     

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Not really...as you see shows the other colours green, they should be still red

       

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        5 years ago

        Hi, Anonymous 

         

        I'm sorry that It is difficult to simultaneously use the maximum and minimum values in the dynamic table as the color format to present gradient colors in multiple measures.

        This is a workaround.It can only display  specific colors within the range, you need to set it yourself according to your needs, as I wrote above.

         

        If it doesn’t solve your problem, please feel free to ask me.

         

        Best Regards

        Janey Guo

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.