Forum Discussion
Dynamic Matrix Column Header
I want to show actual month names instead of column name in matrix header. Below is my usecase
I have a slicer for month name. Once month name is selected from slicer below tables gets updated.
Store name is in rows and other columns are in values. There is none in column section of matrix. I am using field parameter which I believe deneb custom visual do not support.
Current table
| Store Name | Current Month | Previous Month | MOM | QOQ |
| ABC | 100 | 300 | -200 | -20 |
| XYZ | 200 | 400 | -200 | -30 |
| AMC | 300 | 500 | -200 | -40 |
Expected Result- Header names should be dynamic based on slicer selection.
| Store Name | Oct 22 | Sep 22 | MOM | QOQ |
| ABC | 100 | 300 | -200 | -20 |
| XYZ | 200 | 400 | -200 | -30 |
| AMC | 300 | 500 | -200 | -40 |
Hi sahu_mantu
please refer to the linked tutorial, we don't have this option as generic, but there is some workaround with field parameters to achieve this:
https://www.youtube.com/watch?v=9_2m5Csr55cIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Unfortunately i dont think that we have other alternatives.
You can suggest it as idea here :
3 Replies
Hi sahu_mantu
please refer to the linked tutorial, we don't have this option as generic, but there is some workaround with field parameters to achieve this:
https://www.youtube.com/watch?v=9_2m5Csr55cIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
It is good to know we can use field parameters however if there is slicer and calculation is based on slicer then it won't work.
Unfortunately i dont think that we have other alternatives.
You can suggest it as idea here :
