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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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?


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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