Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Relative Date not showing in Slicer visualization ... (Power BI service)

I have a date field, which contains all dates... If I drop it onto a report, and set the visualisation to slicer, the only options I get from the drop down are  "Between" "Before" "After" "List" ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Anonymous,

     

    That is too bad. Indeed, there is a workaround. I just found it minutes ago:smileyvery-happy:. We can use "Page level filters" or "Report level filters". Have a look at the picture please.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

Anonymous's avatar
Anonymous
Not applicable
9 years ago

@v-jiascu-msf... Sorry for pestering you Dale... you do great work here... this would be a really useful workaround for me, but I just cant figure out what you are doing from the screenshots. Can you review my steps in my last post and let me know what I am doing wrong...? 

 

Thanks Dale,

Ger

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous

 

Hi Ger,

 

No problem. I will be very glad if I can help. Just a little busy. You connect the dataset in Service. So we can't manipulate it. Could you please check the source if data type of the column is "Date"? That could be the cause.

 

Best Regards!

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    v-jiascu-msft

     

    Hi Dale - I'm not exactly sure how or why, but today I accidentally stumbled across the relative date field in the Page filter. I am stumped as to why I couldnt get this before because my data model didnt change. In any case, this is working good now. I have a page dedicated to "Deliveries in the next 30 days" and its working perfect. 

     

    If I had one tip for other users trying to get the relative date slicer on the page filter, you should ensure that no other visualisations on the page are selected. I THINK thats what made the difference. 

     

    Thank you for your assistance Dale and most importantly - your persistance in helping me. Kudos on the way!

     

    Ger

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Anonymous

     

    Hi Ger, It's my pleasure. So glad it worked finally. Thank you for sharing with the community.

     

    Best Regards!

    Dale