Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @Jack11
Change Percent to Number in the rules
regards
Phil
Proud to be a Super User!
@Jack11 no worries 🙂
Proud to be a Super User!
Hi @Jack11
Change Percent to Number in the rules
regards
Phil
Proud to be a Super User!
HI @Jack11
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.
Proud to be a Super User!
@PhilipTreacy , i tried the same conditions still not working, the icons are visible only for color code 1
@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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |