6-month trailing interval on the chart

[Syndicate_Admin]

Dear Community, I have a bar chart in PowerBI that currently represents sums of FTE counts for the next 18 months for 2 categories. Kind of like the attached screenshot. Now I would like to see only next month, +6 months later and another +6 months later. For example, January 2024, July 2024, and January 2025. How could I adjust the x-axis dynamically without having to select the desired months each month and republish the Dashboard? Example Shot.png Message 1 of 2 26 Views All forum topics Previous Topic Next Topic 1 REPLY Sort: Syndicate_Admin Administrator Syndicate_Admin Administrator 32m ago Source Community: Power BI | Source Author Name: lbendlin Syndicated - Inbound Remember that you can use measurements as visual filters. Create a measure that labels the desired months, add it to that visual's filters, and set its value accordingly.

[Anonymous]

Hi  @rryryr 

I couldn’t see the attached screenshot in your message. Can you share sample data and sample output in table format or a screenshot again? We can better understand the problem and help you. Please remove any sensitive data in advance.

Best Regards,
Community Support Team _Yuliax