Forum Discussion

id9213's avatar
id9213
Icon for Helper I rankHelper 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...
Need Help
PVO3's avatar
PVO3
Icon for Impactful Individual rankImpactful 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
Icon for Helper I rankHelper 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
    Icon for Impactful Individual rankImpactful 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.