Skip to main content
Microsoft Idea

Power BI

Needs Votes

Expression-based field formatting to display custom values for matrix | table visual

Vote (1) Share
Power BI User's profile image

Power BI User on 06 Jun 2020 00:50:03

I would like to be able to dynamically set my row header values based on a measure or text input. Let's say for instance I have a generic measure to calculate sum of current month based on user selection. The measure name is "CM" for short. If the user selects "April 2020", the field to display in the matrix visual would be "April 2020" instead of "CM". If a user selects "March 2020", then new field display within the matrix would then be "March 2020"