Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jack11
Helper II
Helper II

conditional formatting icon not visible

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 

 

 

Jack11_0-1607924926268.pngJack11_1-1607925124834.png

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @Jack11 

Change Percent to Number in the rules

cf-icon-rules.png

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

7 REPLIES 7
PhilipTreacy
Super User
Super User

@Jack11  no worries 🙂



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
Super User

Hi @Jack11 

Change Percent to Number in the rules

cf-icon-rules.png

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


@PhilipTreacy  thanks alot, it worked!!

PhilipTreacy
Super User
Super User

HI @Jack11 

What do your CF rules look like?  This should work

cf-icon-rules.png

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.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


2020-12-14 20-16-22_sample file - Power BI Desktop.jpg2020-12-14 20-16-32_sample file - Power BI Desktop.jpg2020-12-15 15-42-50_.jpg

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

amitchandak
Super User
Super User

@Jack11 , 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/

 

@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

2020-12-15 12-33-10_New Microsoft Excel Worksheet - Excel.jpg

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.