conditional formatting icon not visible

[Anonymous]

Hi,

I have the dataset in the below format and the result that i want is partially obtained as shown in screenshot 2 , the conditional formatting icons are not visible for color codes 2  & 3, am not sure where am going wrong.

Note: I had unpivoted 3 different date columns 

[PhilipTreacy]

@Anonymous  no worries 🙂

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Change Percent to Number in the rules

regards

Phil

[Anonymous]

@PhilipTreacy  thanks alot, it worked!!

[PhilipTreacy]

HI @Anonymous 

What do your CF rules look like?  This should work

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

@PhilipTreacy , i tried the same conditions still not working, the icons are visible only for color code 1

[amitchandak]

@Anonymous , Can you share a sample pbix after removing the sensitive data.

This is good blog to refer : https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

[Anonymous]

@amitchandak , am not able to attach the file, but here is the screenshot of sample database

Expected result is to see icons for all the dates