Forum Discussion
Helper IIIDate Slider for months
Hi Baarathi88 ,
According to my understanding ,you want to change the slicer's display type,right?
For my test, this is not available currently because the data type of "month-year" is Text and could only be used with the List/Dropdown style. If the data type is "Date" ,then you could use the "Between" style.
Best Regards,
Eyelyn Qin
Hi Baarathi88 ,
According to my understanding ,you want to format slicer's date in “Month-Year”,right?
1.Firstly, you could change the format of the Date directly in Format tabs.
2.If you don't find what you want, then you could customize the data format and sort the value using the following formula:
month-year =
'De'[date].[Month] & "-" & 'De'[date].[Year]sort by year-month column =
De[date].[Year] & "-" & De[date].[MonthNo]
My visualizations look like this:
Is the result what you want? If not, please upload some data samples and expected output.
Please do mask sensitive data before uploading.
Best Regards,
Eyelyn Qin
Helper IIIAnonymous Thank You.
But my condition is bit different, I want to to have the Jan-2019 in a date slider. Refer to below image