Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I am using a between date slicer in my report, however the date column I'm using is months, where the day of each date is set to 1. Is it possible to make the date slicer not have the full date, but use months instead? So when you drag the circles it just snaps from one month to another, without all the dates inbetween? Thanks.
Solved! Go to Solution.
Hi @Newcolator
If you take Between option of slicer it always show you continue date. Its better for just month selection you can either take tile or verticle list or dropdown.
If you dont want calendar as a slicer then take different option under visual slicer setting.
I hope I answered your question!
Hi @Newcolator
If you take Between option of slicer it always show you continue date. Its better for just month selection you can either take tile or verticle list or dropdown.
If you dont want calendar as a slicer then take different option under visual slicer setting.
I hope I answered your question!
Hi @Newcolator
I'm not an expert, but what kind of data type is your Months column? You can easily change the data type of column to mmmm or mm, depending on if you want your full name or shorter.
Maybe show some simple data I can work with or date tables.
Also, I don't like using slicers between. I prefer the dropdown with multiselect, but that's a subjective opinion.
Have a good one.
Choco
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |