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 August 31st. Request your voucher.
Hi everyone,
as the title suggests, I am setting some conditional format in a matrix visual, but Power BI does not follow the rules I set.
I want to have 3 different backgrounds for each value depending on their value, per the screenshots below.
I have tried setting these as percentages but it still doesnt produce the correct results. I would have thought setting as numbers would be the way to go, as i thought percentages would be relative to the total. The numbers in my matrix are percentages but this is just how I want to format the integers.
thanks
GC4002
Solved! Go to Solution.
Hi @Anonymous
just adjust the values.
1 = 100%
0.5 = 50%
0 = 0%
Hey @Anonymous ,
it seems that your values are formatted, try 1, 0.5 ... instead for the rules.
Hopefully this is what you are looking for.
Regards,
Tom
Hi
Try in % where input numbers in decimal points. Ex: write 0.7 instead of 70%.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
Hi @Anonymous
just adjust the values.
1 = 100%
0.5 = 50%
0 = 0%
perfect, thank you! quickest answer I've ever had on the forum 😄
Hey @Anonymous , maybe this makes 5:00PM CEST a perfect time for asking questions 🙂
Regards,
Tom