Show 5 next periods depend of user selection on the selection slicer

[m4xon]

Hi, 

I have following problem, I have a table with quarters from 2022 to 2025, but need to show only 5 quarters on it. 

Starting Q should be the quarter selected by user on the slicer and at this point I have a problem, because I cannot add a disconnected table with YYYY-Q, as this slicer also filters other visualisations. How to solve that problem?

Thank you!

Max

[Anonymous · Accepted solution]

Hi, @m4xon 

You can create a calculated table that lists all quarters, and then format the table so that it contains only quarters in YYYY-Q format.
Create a measure to capture the user's selection from the slicer. This metric will determine the starting quarter. Next, create a measure to calculate the 5 quarters starting from the selected quarters. To make sure that the slicer affects other visualizations, make sure it's connected to the same data model and that the relationships are set up correctly.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

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

[m4xon]

@Anonymousthanks, yes I have two solutions, one with no related quarters table or calculated table as you mentioned. which option is better from performance perspecitve?