How to Set Default Slicer selection to Current Year / Month in Power BI

preview_player
Показать описание
In this video, we'll show you how to set a default slicer selection to current year / month in Power BI. This will make it easy to select your data by year / month without having to remember to select it each time you open Power BI.

If you're using a custom visual in your Power BI report, it can be tricky to set a default slicer selection. In this video, we'll show you how to do it using a custom visual. After watching this video, you'll be able to set a default slicer selection in Power BI easily and quickly!
How to Set Default Slicer selection to Current Year / Month in Power BI

🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉17.How to calculate Running total for date values in Power BI
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Download the pbix file from :
Рекомендации по теме
Комментарии
Автор

❤❤Do not forget to Like, Subscribe and comment which keeps me motivated !🔥🔥
Download the pbix file from :

Link to create your own custom date table in M Query :

powerbizone
Автор

Thanks! Quick question, how do I do this if I have multiple FACTS?

nickymaehler
Автор

for dropdown it needs to be expanded But i want small drilldown button.
help me with this

Thank You

neerajbohara
Автор

Thank you for the video. (1) I do not have access to download the particular visual. Another way to proceed? (2) Instead of the "Current Year", how do you display the "Last available year" in the dataset? Thank You.

veebee
Автор

Suppose I have 2 preselected slicers product and month dependent on each other, On selecting a product from the product slicer i get the default minimum month selected on the month slicer, when I change the selection on the month slicer manually, and now I go back and select another product on the product slicer, the default on the month slicer vanishes, nothing is selected by default. I need to reset and get back the default selection. Can this be avoided? I mean I do not want to use the reset button.

amazo
Автор

Thanks for the info. Instead of years I have weeks and I follow your steps but instead of selecting the current week it selects all the weeks by default. Do you know why?

themolestones
Автор

You also mention is another way, where do I find that video?

nickymaehler
Автор

Thankyou sir. But when I applied the same steps at the end in slicer its by default selecting "All" instead of lastest month could you please suggest me where I am doing wrong

SanaKhan-zehs
Автор

for dropdown it needs to be expanded But i want small drilldown button.
help me with this

Thank You

neerajbohara