Change Row Header based on SelectedValue (Dynamic)

[gauravnarchal]

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

Validation	Identifier - CY
Unique	U2M
Unique	U2Q
Unique	U2U
Unique	U2Y
Unique	U6A
Unique	U6E
Unique	U6O
Unique	U6P
Unique	U6S
Unique	U6V
Unique	U6W
Unique	UKA
Unique	ULB
Unique	ULC
Unique	ULD
Unique	ULE
Unique	ULH
Unique	ULI
Unique	ULK
Unique	ULL
Unique	ULM
Unique	ULN
Unique	ULO
Unique	ULP

[PaulDBrown]

@gauravnarchal 

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

[Anonymous · Accepted solution]

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. 

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

[Greg_Deckler]

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