Forum Discussion
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"
"Dropdown"
(all of which work fine/as expected)
I was expecting to see "Relative"... what am I doing wrong?
(This post seems to indicate that it should be possible)
Thanks,
Ger
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
14 Replies
v-jiascu-msftMicrosoft Employee
Hi Anonymous
The “Relative” isn’t in Power BI Service by now. It’s a preview feature of May release of Desktop. You could reference here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/
There is a workaround. Change the slicer to "Relative" in Desktop, then publish to Service. It will work. Please have a try.
Best Regards!
Dale
Thanks for the response v-jiascu-msft
I was hoping you wouldnt say that :smileyvery-happy::smileyvery-happy::smileyvery-happy:
To be honest, I have my entire set of dashboards/reports done through Power BI Service which was a hell of a lot of work, and I dont want to start using Power BI Desktop now as it would be too much of a change.
Any idea when relative dates will be available in Power BI Service???? I need it really really badly. Is it on the backlog?
Thanks again,
Ger
- v-jiascu-msft
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