Dynamic customer segment size with x-y days since last purchase

[Mikael_B]

Hi.
I need aid with how to create dynamic timeseries analysis of segment size with days since last purchase rule.

End goal is to see size of customer segments with x-y amount of days since their last purchase on timeseries visual (picture below).
Note 1: If user changes max(date) on date slicer, measure should take this in to account.
Note 2 optional: There is going to be multiple segments with different "days since.." filters

Data model:

Due circumstances I can not share pbix.

[v-yueyunzh-msft]

Hi , @Mikael_B 

Based on your description in CASE, it seems that you want to dynamically filter and slice the number of columns and the size of the displayed columns in the line chart in your report based on your date slicer selection? If this is the case, you can do it with Power BI's default visual interaction turned on;

Change how visuals interact in a report - Power BI | Microsoft Learn

For your needs, if your y-axis only shows the values in the corresponding table, you don't need to write measures.

If you want to express something that is not what you mean or you have other concerns, you need to provide some sample data in text format if it is convenient for you, and paste your expected output in the figure or table to reply in the case, which will help us understand your meaning and find a solution to your problem! Thank you for your support and understanding!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly