I have a power bi matrix, but I wish that when selecting a year it would bring me 3 columns and when selecting another year it would bring me only one column, and the final column would be the variation between one year and the other in%. Attached image Thanks a lot.
The solution is not what I need, I'm going to put a few screenshots. of how I want it.
The year slicer is a string type table, it is not a calendar, so when I select year 21 it loads me some metrics that it already creates (as seen in the image), then I create another table that is not related to the model that at the time of press the year to compare, for example 20 brings me a metric (