CODEWITHSUNDEEP
powerbi-desktop
Ameena Bano
Ameena Bano

Reputation: 46

Dynamic 3 years graph in Power BI as per incremental year

How can I create dynamic graph lines in Power BI which shows only three graph lines?

I used filters, but it will not work for every future year. As in, currently restricted it between 2019-2021. But how this can be handled dynamically for year 2022, for every incremental year?

Upvotes: 0

Views: 136

Answers (1)

mkRabbani
mkRabbani

Reputation: 16908

You can use a visual level filter as shown below to achieve your desired output. This will always show the last 3 years' data in the chart:

Enter image description here

Upvotes: 1

Related Questions