Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I would like to use a dropdown list filter on my date like following
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 !
Solved! Go to Solution.
Hi @Anonymous
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
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
Hi @Anonymous
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |