Hi, I have the following dashboard with the ranking of the suppliers on months of the current year using INDEX() function.
Anyway, I just want to hide or format in blank the months that have not passed yet (i.e. feb, march ...etc). Because the INDEX function is ranking the supplier alphabetically because they are all zero right now.
I have tried to use a function that returns 0 or 1 (to colour in white if the month is zero), but is formatting just the measures calculated, not the rows with the name of the supplier and the INDEX.
Thanks,
Stefan
Hi Stefan,
You might try creating a calculation to use as a filter. Possibly something like
[Date] <= TODAY()
Calculations often have to be customized for the data structure and/or the way the view is built. Thus, if you are able to post a sample workbook, we could help find a more specific calculation.
Hope this helps
