Forum Discussion

poli361's avatar
poli361
Helper I
2 years ago
Solved

Dynamic Conditional Formatting based on SELECTEDMEASURE()

Hi I am trying to get a Font rule that works for every Calculation without using conditional format style "Rules" and applying them to every calculation .    I am using a code like that so I ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi poli361 ,

     

    I seem to understand your needs. You want to set the font in the matrix, but the measures in your matrix are replaced or you have multiple measures, but you don't want to re-modify the conditional formatting because of the replacement, or repeatedly set the conditional formatting.

    I'm sorry, it is currently unavailable. You need to erpeat steps each measure you want to apply conditional formatting to.

    Maybe you could submit an idea for this:

    Ideas (microsoft.com)

     

     

    Best Regards,

    Stephen Tao

     

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

Bmejia's avatar
Bmejia
Super User
2 years ago

Conditional formating done at column level.  The only way this would work is if your data all came from a pivot table

 

example:


Measure:

Color =
Var Color_ = if(SELECTEDVALUE(ColorT[Value])>5,"Green")
return Color_

 

 



  • poli361's avatar
    poli361
    Helper I
    2 years ago

    Thank you for replying . I just want to make one measurement to work on any measurement I put . 
    In your example you are using one column "ColorT[Value]" , but I want to use a dynamic column , which will be whatever I put inside the matrix table .