Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to have a slicer that allows users to select data from a consecutive range of months (Jan-Jul, Feb-Sept, etc.) but I don't want them to have the freedom to select it at the "date" level, because all data from each month lives on the 1st day of the month (so selecting January 2nd would eliminate all January data from view).
Any way to make this happen, or am I stuck using a multi-select list slicer?
Hi @enlamparter,
Based on my understanding, you can create a calculated column using the formula: Month = MONTH('Calendar'[Date])
Then add the 'Month' column in slicer, select between mode, you can select the month range as follows.
If you still have other problem, don't hesitate to ask.
Best Regards,
Angelia
Thanks Angelia, that does work as long as my data only spans one year, but since my data spans 2016 and 2017, this doesn't quite serve the purpose I need it to. I probably should have specified that in my original question!
Hi @enlamparter,
If your data only has year, rather than the formate year/month/day? How do you select the consecutive range of months (Jan-Jul, Feb-Sept, etc.) You must have month level.
Best Regards,
Angelia
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |