Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to get the conditional formatting to work on my cards. I am looking at Inventory data and have Age Buckets that have goals associated with it:
I am currently working on the 151 to 180 bucket. The current percent of the Inventory that is in the bucket is 5.52%
When I try to use the Rule format style and use the logic below:
The resulte is in black:
I have also tried to to use the number variation of 5 and 100, but it is the same. I am not sure why the coloration is not switiching accordingly.
I have also tried to use the Gradient formatting style and am having a similar issue:
Again, same issue. The coloration is not correct. I have also, again, tried the whole numbers and having the same issue.
Any help is welcome! Thank you in advance.
Solved! Go to Solution.
Hi @kgdulban
Please download this example PBIX file
Not sure how you are calculating your buckets, see my file for what I've done.
But, if you do something like this
151 to 180 = DIVIDE(CALCULATE(COUNTROWS('DataTable'), FILTER('DataTable', 'DataTable'[Aging Bucket] = "151 to 180")), COUNTROWS(ALL('DataTable')))
Then set up the card and go into the CF rules
It works for me
Regards
Phil
Proud to be a Super User!
Hi @kgdulban
Please download this example PBIX file
Not sure how you are calculating your buckets, see my file for what I've done.
But, if you do something like this
151 to 180 = DIVIDE(CALCULATE(COUNTROWS('DataTable'), FILTER('DataTable', 'DataTable'[Aging Bucket] = "151 to 180")), COUNTROWS(ALL('DataTable')))
Then set up the card and go into the CF rules
It works for me
Regards
Phil
Proud to be a Super User!
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |