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 

 

Thanks for your patience. That would work... however, on my Power BI Service instance, for the page or report level filtering, I only get an "Advanced filter" or "Basic filter" option... there is no option for "relative". Am I doing something wrong?

 

Ger

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey,

 

It(Relative filtering) will work only for date fields. So, make sure your field is in date format and then try.

 

Hope this helps!!!