Forum Discussion
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
| 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 |
- Anonymous5 years ago
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!
3 Replies
- AnonymousNot applicable
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_DecklerCommunity Champion
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-titles-chart-types/m-p/1027881#M444
Maybe use buttons and bookmarks?
- PaulDBrownCommunity Champion
I would think you can. Can you show a mockup of the expected output and a sample dataset?