Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Askreddy18
New Member

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors