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

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

Anonymous

 

Hi Ger,

 

Only date column has that option. Please check it out. I have tested continuous and non-continuous dates. Both work fine.

 

Best Regards!

Dale

Anonymous's avatar
Anonymous
Not applicable
9 years ago

@v-jiascu-msft

 

Hi Dale, I'm really sorry. Still not seeing Relative Date filter. I'm must be missing something obvious. In an attempt to simulate what you have in your screenshot, this is all I have done.

* 1 report

* 1 table visualisation

* 1 column in the table called "Planned Delivery Date"

* Nothing else on the report. 

 

* With the table visualisation selected (or not), I drag the planned Delivery date field onto the page level filter (or report level filter).

* Both reading view and edit view are only showing me Advanced and Basic filter. See image below.... thanks again for your patience.

 

 

Can you explain in words what you are doing. Not entirely sure what you mean by "Only date column has that option." Do I need to setup my data model differently?

  • 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-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

     

  • 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

  • JPVent's avatar
    JPVent
    Frequent Visitor
    2 years ago

    That's a much better explanation thanks