Forum Discussion
Dynamic title in matrix column
Good day,
I need the column title of a matrix to be dynamic with respect to the accounting year I am filtering, what can I use to do this?
I send you an image of what I need:
As can be seen in the image, the FY17 would have to appear in the first column and the FY20 in the second, this must be dynamic since two different accounting periods can be selected from those observed in the image.
Thanks.
Hi Anonymous ,
You can not modify the name of a field or measure through the slicer in current version, but you can try to other solutions.
The principle is similar to the screenshot below. Each measure is bound to the value in the slicer, and the slicer determines which measures are displayed in the matrix.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hey Anonymous ,
you can get the values from the filter with the SELECTEDVALUE function.
But you cannot use them as column title.
You can however use them as title from the visual or in general as a text block.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biHi Anonymous ,
You can not modify the name of a field or measure through the slicer in current version, but you can try to other solutions.
The principle is similar to the screenshot below. Each measure is bound to the value in the slicer, and the slicer determines which measures are displayed in the matrix.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
