Forum Discussion
Only show last value in matrix
Resolver ICould you post your current measure? Using Allselected as a condition in Calculate might fix this.
Edit: Okay you want the slicer to only affect the value column. This is a bit complicated. You may need a new table for the data, lets call it T2. Then instead of a matrix use table visualization. Make a new measurement:
Filtered values = Selectedvalue(T2[Value])Use the weeks from T1 as the first column and the values from T2 as the next column, and the slicer will take in weeks from T2.
The end goal for the measure is to have a line chart with 3 values: current year, year -1 and a value marker just for the last week of the current year. So it doesnt necessarily have to be in a matrix or a table, as long as it just takes the value of the current year value of only the last week so I can have dynamic labels in the line chart visual that move when the slider for the weeks moves.
The easy non-dynamic method would be:
Label = CALCULATE([Value Measure],FILTER('Date','Date'[Year]=YEAR(TODAY())&&'Date'[WeekNum]=WEEKNUM(TODAY())))which works fine, but means I cant select an older week and have the label move dynamically with the slicer.
