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

JPVent's avatar
JPVent
Frequent Visitor
2 years ago

That's a much better explanation thanks