cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alsasloren Member
Member

How to select dynamically current date on filter

Hi all

 

I have a big problem. I exactly need to solve this problem. 

I have a date dimension table as below. It different from standart because i have one fact table and it has both monthly and weekly values. It was joined on ID column. This part is not important. I just want to inform my case.

Our customer wants the filter which named as "Text" dynamically changes for current date. For example in the next month When they open the dashboard from web, they want to see May value to be selected on the filter by itself. That's the first thing. If it is possible then they want one more think.

When 'weekly' is selecting on dimension filter then on the text filter current week should be come with selected.
wdbwadhad.png

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to select dynamically current date on filter

@alsasloren you can set default value to the slicer, I think in the market place there is Power Slicer custom visual that allows to set the default value but I never used it. 






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





1 REPLY 1
Highlighted
Super User
Super User

Re: How to select dynamically current date on filter

@alsasloren you can set default value to the slicer, I think in the market place there is Power Slicer custom visual that allows to set the default value but I never used it. 






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 144 members 1,953 guests
Please welcome our newest community members: