How to show only few bars in Bar chart

[anileshknpowerb]

I have a bar chart that shows Revenue by Years. By default it shows data for all years. I need to show the bars for Current year+2, ie, suppose current year is 2020, bar should only show for 2020, 2021 and 2022.

How do i achieve this?

[v-zhenbw-msft]

Hi @anileshknpowerb ,

How about the result after you follow the suggestions mentioned in my original post?
Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution.

Best regards,

Community Support Team _ zhenbw

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

[v-zhenbw-msft · Accepted solution]

Hi @anileshknpowerb ,

We can create two measures to meet your requirement, one calculates the next year value, another calculates the next two years value.

Next_year = CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),'Table'[Year] = MAX('Table'[Year])+1))

Next two year = CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),'Table'[Year] = MAX('Table'[Year])+2))

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

It will be helpful if you can show us the exact expected result based on the tables.

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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

[Daviejoe]

Nice!

[Daviejoe]

Do you have a date table?

Test out adding a calculated column into your date table that gives a identifies the current year and the following two years and you can apply that as a filter on the visual.

[parry2k]

@anileshknpowerb you can use relative date filtering

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡