Conditional formatting Icon not visible

[JCK2]

Hello, any idea why Im not see the icons on the table? I have the icon on and also have the conditional formating set with no error but in the table it is not showing the icon? 

[v-yingjl · Accepted solution]

Hi @JCK2 ,

Based on my test, conditional format seems work fine in my environment. Maybe you can consider these limitations when using conditional format:

In addition, seems you have not used the latest version of power bi desktop, you can try to update it: https://www.microsoft.com/en-us/download/details.aspx?id=58494

If the above not help, could you please share some sample data or a dummy .pbix for further discussion?

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-yingjl · Accepted solution]

Hi @JCK2 ,

Based on my test, conditional format seems work fine in my environment. Maybe you can consider these limitations when using conditional format:

In addition, seems you have not used the latest version of power bi desktop, you can try to update it: https://www.microsoft.com/en-us/download/details.aspx?id=58494

If the above not help, could you please share some sample data or a dummy .pbix for further discussion?

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[JCK2]

Thanks for looking into this!

Find attached a sample data, it works when i have a category in the table, it does not work when i want it at summary level.

https://www.dropbox.com/s/7vmeec4jg22gycf/Powerbi.pbix?dl=0

[az38]

@JCK2 

I do not see any problem in your pbix- file

what action should we do to get your issue?

[JCK2]

My aim is to achieve the conditional formating at aggregate level, the icons disappear the moment i uncheck site from the table.

i want to see the icons at Total level...

[az38 · Accepted solution]

@JCK2 

I just removed all your conditions rules and recreated it again:

PBIX in attach

[JCK2]

Thanks an upgrade did the job :)! Thanks a lot once again! stay safe! 

[az38]

@JCK2 

is there any aggregation in visual with your [Action Diff] field?

Is [Action Diff] column or measure?

[JCK2]

Action diff is a measure, comparing to same time last year performance...

[JCK2]

Just an update, it will perfectly when added rows, but when aggregating it does not seem to work 😞