Forum Discussion

id9213's avatar
id9213
Helper I
3 years ago

Dates slicer format

Hi guys,

 

I have a little issue with dates in a slicer.

I am using date hierarchy in a slicer which is quite useful. Unfortunately, the issue is I can choose every single day even if they are not in my original database.

Is there a way to fix this?

Thanks a lot for your help!

Need Help

3 Replies

  • PVO3's avatar
    PVO3
    Impactful Individual
    3 years ago

    Lot's of ways to solve this. Not sure what your prefered way is, but below is problably the easiest:

     

    You can use this as a visual filter in the filter pane, as 'is not blank'.

    Assuming you have a Dim 1 → * Fact relationship

       

     

    Measure = 
IF(
    NOT ISBLANK(COUNTROWS('FactTable')),
    1
)

     

     

    • id9213's avatar
      id9213
      Helper I
      3 years ago

      Thanks a lot for your quick answer PVO3 

      I am not sure to understand your solution. Sorry maybe I did not present my problem the right way.

      My database is structured this way:

      Each line corresponds to a specific company each employee are working on. So, of course, since it is on a weekly basis, I have several time the same date.

      I would like to avoid having for example 01/01/2017...03/01/2017...04/01/2017 in my list since there are no line containing those dates in my database.

       

      Thanks a lot!

      • PVO3's avatar
        PVO3
        Impactful Individual
        3 years ago

        The solution I provided works. But like I said i'm assuming you have a Dim 1 → * Fact relationship. Your Dim is a date/calendar table. Based on your reply I don't think you're currently using a date/calendar table. Be sure to use one. Depending on your measure, you might not even need the measure I provided earlier.