Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 @Anonymous
Change Percent to Number in the rules
regards
Phil
Proud to be a Super User!
@Anonymous no worries 🙂
Proud to be a Super User!
Hi @Anonymous
Change Percent to Number in the rules
regards
Phil
Proud to be a Super User!
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.
Proud to be a Super User!
@PhilipTreacy , i tried the same conditions still not working, the icons are visible only for color code 1
@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/
@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 |
---|---|
106 | |
86 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |