cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yuvaraj Regular Visitor
Regular Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

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

Hi @Yuvaraj,

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

Create a parameter in query editor:

1.PNG

Add a culstomer column in Table 1:

2.PNG

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

1.PNG2.PNG

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yuvaraj Regular Visitor
Regular Visitor

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

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

Community Support Team
Community Support Team

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

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

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

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.