dynamic date grouper based on date slicer selection

[tatenda24]

I need help on the following problem on a bar chart.

So if a date slicer selects a date, I would like for 4 date groupings (of total sales) determined by the date selected on the slicer.

Essentially I want the selected date on the slicer to the beginning of the first group(bin). if the first group(bin) is from (2016-05) then that bin and every other bin should be 11 months wide) therefore second bin would start 2017-04) and so forth. 

now I want this dynamic such that if any date is selected as the start date in the slicer(date selector), the following bins all change while accounting for the aforementioned parameters. 

link to sample data : https://drive.google.com/file/d/1ne9jZNEW7-eL3zgwNzaOHHgMZNkhulJX/view

Please help if you can! thank you very much 

[tatenda24]

need help and a solution on the following problem in the form of a bar chart;

So if a date slicer selects a date, I would like for 4 date groupings (of total sales) determined by the date selected on the slicer. Essentially I want the selected date on the slicer to the beginning of the first group(bin). if the first group(bin) is from (2016-05) then that bin and every other bin should be 11 months wide) therefore second bin would start 2017-04) and so forth. now I want this dynamic such that if any date is selected as the start date in the slicer(date selector), the following bins all change while accounting for the aforementioned parameters.

How would one achieve this through DAX? any other way of solving this is welcome too

link to sample data: https://drive.google.com/file/d/1ne9jZNEW7-eL3zgwNzaOHHgMZNkhulJX/view

Please help if you can! thank you very much.

[amitchandak]

@tatenda24 ,

refer if this can help

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[parry2k]

@tatenda24 it will be easier if you share sample data and expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[tatenda24]

Hi there, this is the link to a sample file. 

As for expected results. I generally want to learn how to be able to bin total sales as per the dynamic groups(bins) of the dates that are determined by the slicer as mentioned above. hope the data can help you help me 

https://drive.google.com/file/d/1ne9jZNEW7-eL3zgwNzaOHHgMZNkhulJX/view?usp=sharing