Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | OccupiedSeats | School Name | Buildings |
21-03-2021 | 10 | 1 | School1 | Building1 |
22-03-2021 | 10 | 4 | School1 | Building1 |
23-03-2021 | 10 | 4 | School1 | Building1 |
24-03-2021 | 10 | 1 | School1 | Building1 |
25-03-2021 | 10 | 2 | School1 | Building1 |
26-03-2021 | 10 | 1 | School1 | Building1 |
27-03-2021 | 10 | 1 | School1 | Building1 |
21-03-2021 | 12 | 5 | School1 | Building2 |
22-03-2021 | 12 | 8 | School1 | Building2 |
23-03-2021 | 12 | 8 | School1 | Building2 |
24-03-2021 | 12 | 3 | School1 | Building2 |
25-03-2021 | 12 | 4 | School1 | Building2 |
26-03-2021 | 12 | 2 | School1 | Building2 |
27-03-2021 | 12 | 4 | School1 | Building2 |
Expected Output: it should either color the cell containing weekend[Saturday and Sunday dynamically] as red or it should color its font as red.
@deb_power123 , In matrix you cam can not color values in row and columns
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |