Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Can anyone please help me with below case
ID Date Rank
23 01/01/2024 1
23 01/01/2024 2
23 01/02/2024 3
23 01/02/2024 4
24 01/01/2024 1
24 01/01/2024 2
24 01/02/2024 3
I want to highlight where Rank is minimum with the date range for example -
23 01/01/2024 1
24 01/01/2024 1
Here i want to highlight (background color) above Rows since they have minimum Rank, but when user select date 01/02/20204 then i want to highlight below rows since they have minimum rank per that date
23 01/02/2024 3
24 01/01/2024 2
Thanks in Advance
Try this code in the background color expression under the Rank dimension,
if(Rank = min(total <Date> Rank), RGB(169,208,142), white())
Try this code in the background color expression under the Rank dimension,
if(Rank = min(total <Date> Rank), RGB(169,208,142), white())