Forum Discussion
Conditional Formatting using slicer values
Hi All, Let's say I have the following data in a table visual: Month Reported January January December November November November October And I have a slicer: Reporting Month and t...
Hi Anonymous ,
Based on my test, you could refer to below steps:
Sample data:
Create a new table:
New = VALUES(Table1[Month Reported])
Use this column as slicer.
Create a new measure:
Measure = IF(MAX('Table1'[Month Reported])=SELECTEDVALUE(New[Month Reported]),"#FD625E")Set conditional formatting:
Now you could get the result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi Anonymous ,
Based on my test, you could refer to below steps:
Sample data:
Create a new table:
New = VALUES(Table1[Month Reported])
Use this column as slicer.
Create a new measure:
Measure = IF(MAX('Table1'[Month Reported])=SELECTEDVALUE(New[Month Reported]),"#FD625E")
Set conditional formatting:
Now you could get the result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi v-danhe-msft,
Thank you so much for your reply. I've resolved this before your reply but I used a similar approach as yours.
Appreciate it!