Can we create a slider to shown dimension like MonthYear?

[shilpagupta1687]

Hi Friends,

I am wondering if anybody has an idea if we can create a slider showing MonthYear say '2022-Jan' as the values on the slider. As per my understanding we can only show some numerical values on the slider. Please advise me.

I want to show in a map how the sales is changing with the MOnthYear selected in the slider.

Thanks,

Shilpa

[vinieme12]

Yes , as below

Calendar:
Load
Date
,rand() * 300 as Sales
,MonthYearIs
,Autonumber(MonthYearIs) as MonthNum
,pick(ceil(Rand()*4),'RUSSIA','INDIA','JAPAN','GERMANY') as Country
;
Load monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1) as Date
,Monthname(monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1)) as MonthYearIs
,month(monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1)) as MonthIs
Autogenerate 1
While monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1) <= date#('2022-01-01','YYYY-MM-DD')
;

Create a variable = vMonth  empty definition

Drag a Variable Input onto the sheet from Custom Objects >> Variable Input

Choose Variable = vMonth

min value = Min(MonthNum)

max value = Max(MonthNum)

Step =1

General Title for Slider = only({<MonthNum={"${vMonth}"}>}MonthYearIs)

In you Map chart

use expression =  Sum({<MonthNum={"$(vMonth)"}>}Sales)

[shilpagupta1687]

Hi Vineeth,

Thank you so much for your response.

Let me try and check this. I will keep you posted.

Regards,

Shilpa