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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
gauravnarchal
Post Prodigy
Post Prodigy

Change Row Header based on SelectedValue (Dynamic)

Is it possible to change the row header name of a table or a matrix based on a selectedvalue measure?

 

For eg:- I have a measure create for selectedvalue "Identifier - CY & Identifier - PY"

 

I wanted when i select Identifier - PY row header should also show Identifier - PY instead of Identifier - CY

 

ValidationIdentifier - CY
UniqueU2M
UniqueU2Q
UniqueU2U
UniqueU2Y
UniqueU6A
UniqueU6E
UniqueU6O
UniqueU6P
UniqueU6S
UniqueU6V
UniqueU6W
UniqueUKA
UniqueULB
UniqueULC
UniqueULD
UniqueULE
UniqueULH
UniqueULI
UniqueULK
UniqueULL
UniqueULM
UniqueULN
UniqueULO
UniqueULP
1 ACCEPTED SOLUTION
Sumanth_23
Memorable Member
Memorable Member

hi @gauravnarchal - A method that I have used to achieve this is to overlay your table headers with the Card visual and assign the visual a measure which dynamically calculates the required dynamic title as seen in the below screen grab. 

 

All columns in the table are individual card visuals overlaying the table/matrix visual - you have manually take care of the alignment though. 

Sumanth_23_0-1600175390768.png

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

@gauravnarchal 

I would think you can. Can you show a mockup of the expected output and a sample dataset?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Sumanth_23
Memorable Member
Memorable Member

hi @gauravnarchal - A method that I have used to achieve this is to overlay your table headers with the Card visual and assign the visual a measure which dynamically calculates the required dynamic title as seen in the below screen grab. 

 

All columns in the table are individual card visuals overlaying the table/matrix visual - you have manually take care of the alignment though. 

Sumanth_23_0-1600175390768.png

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Greg_Deckler
Super User
Super User

@gauravnarchal Probably not, but check this out to see if there might be a way: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...

 

Maybe use buttons and bookmarks?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.