cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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 :

ssss.png

 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 3
Super User II
Super User II

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

hello  ,

 

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.

Hi 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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors