How to use Month-YYYY in Visual/page/report filter as between

[anileshknpowerb]

Hi,

I have a date diimension and I have derived a new column Mon-YYYY from it.

I have data like below:

Mon-YYY  Sales

Nov-2019  70

Dec-2019  90

Jan-2020  100

Feb-2020  90

Mar-2020  60

I want to use Mon-YYYY as visula/page/report filter like between and show data

How can I use Mon-YYYY column as page/report/visualization filter ans show data between say, Dec-2019 to Feb-2020 like below:

Mon-YYYY Sales

Dec-2019  90

Jan-2020  100

Feb-2020  90

Thanks,

Anilesh

[v-juanli-msft]

Hi @anileshknpowerb 

If [Mon-YYY] is a text type column, it can't show  as "between".

If [Mon-YYY] is a date column or you use a date column, yoou can add it to a slicer where you can select "between".

Best Regards

Maggie

[Greg_Deckler]

You can use the Filter pane and either filter on that column or your original Date column.