cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trungnguyen0000
Helper IV
Helper IV

Filter with single select without value selected by default

Hi guys,

 

I would like to use a dropdown list filter on my date like following

trungnguyen0000_1-1631969512388.png

trungnguyen0000_2-1631969527665.png

 

I enable the single select for this filter then 2019 and all of its months are selected by default.

 

Do you know if I can disable these values by default or use an another filter component ? because at the opening of this report, the users should see data based on the same day.

 

The users should select only one month if they want filter on date.

 

Thank you !

 

 

 

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @trungnguyen0000 

That slicer whouldn't help you the way you want it. I recommend seperating the date (YEAR, MONTH,WEEK...) into different slicers for each of them.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

3 REPLIES 3
trungnguyen0000
Helper IV
Helper IV

thank you for the answer !

 

I'm going to use 2 filters (1 for year and another for month) with option multiselection with CTRL hoping that the users won't push ctrl and click many values .

 

I have a date table which = calendar (min(Invoice[date]),today())

 

I use the year level of the date hierarchy for the filter on year and it's same for month. I noticed that I have null value in my filters. Do you know why ?

 

when we reach the next year, my filter will work ?

Yes and it is normal because you have gaps in the column date of the invoice table. Just use the filter pane in the desktop to filter out the blanks

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973
Community Champion
Community Champion

Hi @trungnguyen0000 

That slicer whouldn't help you the way you want it. I recommend seperating the date (YEAR, MONTH,WEEK...) into different slicers for each of them.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

Top Solution Authors