Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
sharpers4567
Frequent Visitor

Conditional formatting rows

HI all, I am not entirly sure how to achieve this and unable to find an answer so an help would be great.

I have a table of events that occur and the date it occurs. I have created a table to show the events and then new cxolumns from measures to show the proportion number of events per day, monday, tuesday ect.
Is there a way to conditionally format this table to show the lowest occuring day. I am able to format the lowest/highest event for each day, but I was wondering if it is possible the other way round? 

sharpers4567_0-1707837744387.png

Something along these lines in powerbi if that makes sense?


Again, thank you in advance for any tips or solutions 🙂 

3 REPLIES 3
Anonymous
Not applicable

Hi @sharpers4567 ,
Based on your description, you want to format the minimum value, you can go to Format->cell elements->background color and use conditional formatting.

vheqmsft_0-1707900375007.png

You can refer to this document to set the conditional format
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi @Anonymous , I was able to do this for each column but not for each row, am I  missing something?

Anonymous
Not applicable

Hi @sharpers4567 ,
Please provide the full pbix file, hide sensitive information in advance, and use exel or screenshots to show the results you want, so we can help you solve the problem faster.

Best regards,

Albert He

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.