cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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 found the following report (link below) that managed to either do the trick, or format it on the source side, which is not likely because of the difference in language.

 

 Capture.PNG

 

Is there indeed a trick for this?

 

Kind regards,

 

Michiel

 

https://app.powerbi.com/view?r=eyJrIjoiZDRmOTA2ODMtMDk4My00YzEzLTkxYjItNTYzZGUwZTgxZWJmIiwidCI6IjU3N...

 

1 ACCEPTED SOLUTION
Microsoft
Microsoft

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,

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

View solution in original post

8 REPLIES 8
Helper V
Helper V

Hi Michiel,

 

How did you ctreated the Matrix on Page 4 ? did you use the default matrix with Power BI or Custom one

Can you share page 4 with us I would like to see how do you laid out the column?

 

Thanks,

Ed Dror

 

Dear @odeddror ,

 

The report is not mine, but a publically available sample report (couldnt find the pbix however).

 

The matrix is standard but they inserted a background to make it look fancy. Try using Vectr (or paint 8d)! 

 

Kind regards, 

 

Michiel

Michiel,

 

Thank you

Oded Dror

Microsoft
Microsoft

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,

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

View solution in original post

Hi there,

 

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

 

Thanks

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

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?

unichar showing problem.png

Thanks.

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thank you for your reply/soltuion 🙂 The report is a demo! 

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors