Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |