Forum Discussion
dador33
5 years agoFrequent Visitor
Filter value withj columns in the same Matrix
Hi, 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 v...
Mohammad_Refaei
5 years agoSolution Specialist
You can create a table of the 2nd year values and write a measure to capture he values for the selected year based on this table.
Please check this sample file
dador33
5 years agoFrequent Visitor
Hi the solution is not work because the year is only a String is not calendar .
is another function exists?