How to Highlight dates in the slicer which contains data?

[MartinHab]

Hi guys,

I am having date table which I use for slicer (please find below). However, not all dates contains data which can be displayed. Is there a way to highlight dates in slicer which have data so users do not have to click on every single day to figure out that there are data to be displayed? Hope it makes sense 🙂

Thank you!

Martin

[Anonymous]

Hi @MartinHab 

It seems this is not supported at present. If we hope to use a measure to evaluate a result based on each date, we will find that the context is completely the same for each value in the slicer. A value in a slicer cannot filter the slicer itself, thus it cannot affect a measure which we would hope to use for conditional formatting in the slicer.  

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[MartinHab]

Hi guys,

@Anonymous 

@danextian 

thank you for your answers, I was afraid that this will be the case. Hope it will be there in future updates 🙂

Cheers,

Martin 

[danextian]

Hi @MartinHab ,

Tried to do this with conditional formatting on the new slicer but the conditional formatting doesn't work properly. It is supposed to fill the buttons gray if a measure =  x amount but it just doesn't work.