Table visual: can you rename a column by using a variable?

[erikbeauch]

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!

[Ritaf1983 · Accepted solution]

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=JVjeisHA6FU

https://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

[erikbeauch]

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 🙂