Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional formatting totals/subtotals

Dear PowerCommunity,   When you try to format a value or symbol based on a value it will not work for the totals and subtotals. I came across this issue a few times in the forum but I have also fou...
Need Help
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Michiel,

     

    Please don't share anything confidential here.

    That could be only a measure which shows up the Emoji. Please refer to the demo below.

    Measure 9 =
IF ( [Measure 11] <= 70000, UNICHAR ( 128308 ), UNICHAR ( 128309 ) )

    Conditional-formatting-totalssubtotals

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Michiel,

 

Please don't share anything confidential here.

That could be only a measure which shows up the Emoji. Please refer to the demo below.

Measure 9 =
IF ( [Measure 11] <= 70000, UNICHAR ( 128308 ), UNICHAR ( 128309 ) )

Conditional-formatting-totalssubtotals

 

Best Regards,

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi there,

 

The green and yellow circle unichar codes don't work. Do you know how this report was created? 

 

Thanks

  • ddunn801's avatar
    ddunn801
    Frequent Visitor
    6 years ago

    Go to Conditional Formatiing, Icons = On, Advanced controls, then Totals only.