topic Conditional formatting rows in DAX Commands and Tips

Conditional formatting rows

sharpers4567 — Tue, 13 Feb 2024 15:31:33 GMT

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?

Something along these lines in powerbi if that makes sense?

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

Re: Conditional formatting rows

Anonymous — Wed, 14 Feb 2024 08:48:16 GMT

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.

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

Re: Conditional formatting rows

sharpers4567 — Wed, 14 Feb 2024 08:52:56 GMT

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

Re: Conditional formatting rows

Anonymous — Wed, 14 Feb 2024 09:18:56 GMT

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