cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gauravnarchal
Post Partisan
Post Partisan

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
Super User
Super User

@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!



View solution in original post

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!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!