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
7 years ago

Hi v-jiascu-msft ,

 

your solution is so good, but after I use it in my report, my collegues said he can't see the blue/red circle on the website, only see a weird circle, do you know the reason?

Thanks.

Aiolos Zhao