Change Matrix table visual column dynamically

[Anonymous]

I have sum of sales for three years 2019,2020,2021 when i enter 2022 i need to display 2020,2021,2022 but here getting sum of sales by using measure how can i change measure name dynamically when i enter into 2022 year.

ex now i have like this

I want like this

[Anonymous]

Hi @Anonymous ,

I don't think it's possible. You requirement sound like Power BI automatically add and remove measure into the visual.

Best Regards,

Jay

[VahidDM]

Hi @Anonymous 

Set a TOP N  filter on Year column to show the top 3 years.

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[Anonymous]

Actually am taking years as measure,because i need to fetch one year data from another table also,so now how can i change the measure value

[VahidDM]

Hi @Anonymous 

Could you please share your model here? Sample of data or the best way is to share the sample Power Bi file *.PBIX format.

Try to add column to the table by using that measure code, then use column or measure in the filter.

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!