Dynamic Matrix Column Header

[sahu_mantu]

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

[Ritaf1983 · Accepted solution]

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_2m5Csr55c

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

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_2m5Csr55c

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[sahu_mantu]

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.

[Ritaf1983 · Accepted solution]

Unfortunately i dont think that we have other alternatives.

You can suggest it as idea here :

https://ideas.fabric.microsoft.com/