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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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