Forum Discussion
Set filter (slicer) value on load power Bi service cloud
Hello,
there is a way to set slicer value on load ?
My slicer date :
Slicer data table :
in the slicer i want to set value dynamiclally on load:
Start date = first day of month
End date = end of month
Best regards
3 Replies
- GilbertQ
Super User
Hi there,
In order for this to work you need a value that does not change in a column, which will then allow you to create a filter. The underlying data associated to the value will change in another column.
What you would need to do, is to create a new column your date Date table which would have a static value which would be "First Day of Month", this would check the current date and then change based on the date.
You could then do the same for the "End of Month"
You then set these new column values as defaults for your slicers.hello GilbertQ ,
The slicer is populated with only one column, there's no way to set two columns to make your approach.
That's why I'm looking if there is a way to change the slicer values dynamically when loading the page.
If you have an example, please send it to me.
- GilbertQHi there
Currently there is no way to change the slicer values dynamically.
You would have to create a separate new column and use that as a filter on the page
