Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculation item for conditional formatting

Hi!

I have a matrix with several measures and would like to do some conditional formatting. It is the same rule for each measure, so it seems obvious to use the SELECTEDMEASURE()-function.

I use tabular editor and make a calculation item

For example:
cf =
IF(SELECTEDMEASURE() > 0, "#F7F7F7", "#ABABAB")

After saving I get this "Name" column in my model, as expected, but for some reason I can't select it when using field value in the condition formatting pane. 

Does anyone have an idea?

Thank you!

1 Reply

  • Hi Anonymous ,

     

    The calculation groups are use to change the calculations you use on your report, and cannot be used directly on your condittional formatting.

     

    Please check the usecase below: