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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
deb_power123
Helper V
Helper V

DAX to color the font into red or cell into red for weekends in Table Matrix visualization

Hi All,

 

I want to color the font or the cell containing the weekends[ Saturday and Sunday] into red in table matrix. Is that possible ? Can we handle it using DAX? Please suggest

 

My sample input data is as below :-

   Date      TotalSeats    OccupiedSeatsSchool  Name Buildings
21-03-2021      10          1School1Building1
22-03-2021      10          4School1Building1
23-03-2021     10           4School1Building1
24-03-2021     10           1School1Building1
25-03-2021     10          2School1Building1
26-03-2021     10          1School1Building1
27-03-2021    10         1School1Building1
21-03-2021    12          5School1Building2
22-03-2021    12          8School1Building2
23-03-2021    12          8School1Building2
24-03-2021    12          3School1Building2
25-03-2021    12         4School1Building2
26-03-2021    12         2School1Building2
27-03-2021    12         4School1Building2

 

Expected Output: it should either color the cell containing weekend[Saturday and Sunday  dynamically] as red or it should color its font as red.

 

show.JPG

1 REPLY 1
amitchandak
Super User
Super User

@deb_power123 , In matrix you cam can not color values in row and columns

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.