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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-janeyg-msft

Thank for helping me out

But I need to paint according to the dynamic table.

Any idea?

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

    it is what you did, but you added the numbers manually...I need the table (with colours) to consider the max values and min value out of that dynamic table automatically

  • 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