Forum Discussion
Table visual: can you rename a column by using a variable?
Hi, I have specific measures that are named like this:
- LastMonthValue
- LastMonth-1Value
- LastMonth-2Value
- Etc
Each measure is using EOMonth() vs. Today to set the proper time period. When I bring those measures as columns in a table visual, I would like them to be dynamically renamed to reflect the month they represent, eg:
- LastMonthValue column renamed to 2023-08
- LastMonth-1Value column renamed to 2023-07
- LastMonth-2Value column renamed to 2023-06
Is there a way to achieve this? Outside of the "Rename for this visual" option, which requires manual editing, I have not found a way to have this automated. Thanks in advance for your help!
Hi erikbeauch
Unfortunately, we don't have this option in a generic way.
Please vote for the idea about this issue here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=857f02e2-db57-49ab-a9d5-49430ae915b7
(i voted 🙂 )
As an alternative, there are some workarounds with matrixes.Please refer to the linked tutorials:
https://www.youtube.com/watch?v=JVjeisHA6FUhttps://www.youtube.com/watch?v=zbKNyFu2BOo
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi erikbeauch
Unfortunately, we don't have this option in a generic way.
Please vote for the idea about this issue here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=857f02e2-db57-49ab-a9d5-49430ae915b7
(i voted 🙂 )
As an alternative, there are some workarounds with matrixes.Please refer to the linked tutorials:
https://www.youtube.com/watch?v=JVjeisHA6FUhttps://www.youtube.com/watch?v=zbKNyFu2BOo
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983 thanks for your reply, I upvoted the idea. Using a Matrix could be an alternative, but in my specific case, I need to apply conditional formatting on all columns. With a Matrix, when using the unstepped layout and 3 fields in rows (which become the first columns of the matrix), those don't support conditional formatting. Hence reverting back to a table. It would be really nice if the column in the visual could use a Fx to get its name, just like the title of the visual.
- Ritaf1983
I agree 🙂
