Forum Discussion

y_s_c's avatar
y_s_c
Frequent Visitor
2 years ago
Solved

Conditional formatting stops working when using slicer

Hi there,   I've got a matrix with some basic measures that display calculated percentages for, say, a bunch of companies in different geographies. The matrix uses condititional formatting to colou...
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi y_s_c 

     

    I think the issue is caused by the ALL(Table1[Something]) in the measures.

     

    Can you tell me the bahaviour you would like to acheive in the visual?

    Example when you filter Europe what do you want to see? Do you want the colour formatting to Jump to Europe, but still see all the other continents?

     

    The colour coding logic doesn't make sense, you will always have less than All and Never More than all. Is there a % value that we can measure against?

     

    Asia colour formatting = 
IF (
    [Asia %] = BLANK (),
    "",
    IF (
        [Asia %] < [All],
        "#feb5b1",
        IF ( [Asia %] > [All], "#cee2cd" )
    )
)

     

     

     

     

     

     

     

     

     

Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

Hi y_s_c 

 

Can you share how you created both measures? Are both measures calculated from the same table? If not, do both tables share the same dimensions?

 

As Anonymous  mentioned, if you could share a PBIX or provide more information on your data structure. Relationships, Measures etc, this will help us find you a solution

 

Joe

ytkweh123's avatar
ytkweh123
New Member
1 year ago

Hi there,

 

I encountered a similar issue by applying conditional formatting using measures and when I slice the data by calculation group, the conditional formatting that was originally there disappeared for 1 of the measures. Does anybody know what is happening and how to solve this? The formatting works on a card visual with 1 measure but on a bar chart with 5 measures, it doesn't work when calculation group is applied. Other measures that uses the simple conditional formatting (not by measure) still works when calculation group is applied.

 

 

Thanks!