Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
User | Count |
---|---|
16 | |
14 | |
13 | |
12 | |
11 |
User | Count |
---|---|
19 | |
16 | |
15 | |
11 | |
9 |