The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have built a PBIX file and it has png files as icons. I want to change the bachground colours based on the sum of response score (filtered by the ClientName and the category) but, the colours are taking up as a total of the entire category and hence, not displaying as they are supposed to.
Can anybody please help?
Please find the pbix file and the dataset
Here
https://filebin.net/0bvp0ygcvgo6uplu
Thanks,
Harshad
Files you shared with are not the excel file or pbix file.
I can't use the data from them.
how about trying to use a measure instead?
like measure=sum([column])
then use this measure in the conditional fromatting.
Best Regards
Maggie
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
63 | |
47 | |
41 |