Dear community,
I am facing some issues with conditional formatting that I do not understand.
It is based on the share of a category within another table.
I based the background color (grey) in the left row on a rule of >5%. How can it be that also lower values are colored? (e.g. the 8 in the end represents 0.92%, why is it still in grey?
Note:
All filters are removed.
Hi, @ddorhout
You should use 'number' as condition, then it will display correctly.
'Percent' is used to filter the range, not for every percentage of the number.
Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Hi, @ddorhout
You should use 'number' as condition, then it will display correctly.
'Percent' is used to filter the range, not for every percentage of the number.
Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
