how to set the bucket range for n months using date dimension

[Yuvaraj]

Hi

I have been creating filter for last 6,18,30 months from current date or max date.

Date format:

08-06-2018 

14-06-2018

15-06-2018 

19-06-2018 

21-06-2018 

22-06-2018

i have date dimension like this for 2016,2017 & 2018 years.

Expected filter:

Month range:

0 to 6 months

0 to 18 months

0 to 30 months

[v-danhe-msft]

Hi @Yuvaraj,

Based on my test, you could refer to below steps:

Create a parameter in query editor:

Add a culstomer column in Table 1:

Apply it and you could use the edit parameters function to get your filtered data:

You could also download the pbix file to have a view:

https://www.dropbox.com/s/kb0dd3nqh7nx47j/how%20to%20set%20the%20bucket%20range%20for%20n%20months%2...

Regards,

Daniel He

[Yuvaraj]

Hi Daniel,

Thanks for your response

Is it possible create like one dimension from there if i choose range values it automatically filter the values but here everytime i have to choose Edit Parameter and select the values in drop down.

Regards,

Yuvaraj

[v-danhe-msft]

Hi @Yuvaraj,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Yuvaraj,

I have tested to get what you want, but I am afraid you could not achieve this feature currently, you may submit an idea in Ideas forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He