Forum Discussion
Help needed for Filed parameter
i have matrix visual, where i am showing 2 measures, CurrentYearMonth_Sales, LastYearMonth_Sales.
I have a slicer for YearMonth. Based on slicer selection, I have to dynamically update the measure names CurrentYearMonth_Sales, LastYearMonth_Sales to Lastday of the slicer selcected value.
For ex:. if 2022-09 is selected, show measure names as, 09-30-2022 Sales, 09-30-2021 Sales.
I set up filed parameters for this and using SELECTEDVALUE function but its not working
Can't have dynamic measure names. You need to prepare all possible names in a reference table and then control column visibility by a measure.
1 Reply
Can't have dynamic measure names. You need to prepare all possible names in a reference table and then control column visibility by a measure.