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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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?


@ 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors