Forum Discussion
Default value in the filter
HI All,
How can I add a default value dynamically in the filter pane but still the drop down have other values as well.
TIA
2 Replies
- VasTgMemorable Member
Anonymous
I don't think there is an option to choose a default value dynamically in a slicer or filter pane.
I had a similiar situation for month slicer and I want to show the latest month as default.
Ended up duplicating the month column and dynamically placing the value "Current" for latest month flag.Then used the "New Column" in slicer with Current value as default. The new column updates when the month rolls over based on Latest month flag.
Month New Column Current Month flag Dec-19 Current 1 Nov-19 Nov-19 0 Oct-19 Oct-19 0 If this helps, mark it as a solution.
Kudos are nice too
- v-alq-msftCommunity Support
Hi, Anonymous
It is unavailable to set a default value directly in the filter pane dynamically in Power BI currently.
You may refer to the following links:
https://community.powerbi.com/t5/Desktop/Filters-with-default-value/m-p/790828
For further information, you can post a new idea in Idea Forum with the following link, and add your comments there to improve Power BI for making it coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.