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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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