Dynamic Measure Name in Matrix

[jbora0494]

Hi Everyone,

I am using Matrix visual in which I have Market in Column card, Category in Row card and 5 measures in Values. These measures are formatted string as we need to show "Current Year Value | Vs PY Value" in all 5 measures. I am using slicers also. On the basis of slicers, I want to showcase only 3 measures at one time. I tried multiple ways, I am getting the blanks for the measures that I want to hide for all Market and Category but not able to hide those.

Any help is much appreciated.

Thanks,

Jyoti Bora

[alish_b · Accepted solution]

Hey @jbora0494 ,

Please try using Field parameters for this. Under Modeling>New Parameter>Fields, drag and drop the 5 measures in the Parameter setup. Once you create it, it should add a slicer with all the measure names that you can select from. Then, in the matrix visual, use the Parameter in the Values section instead of the individual measures.

Hope it helps!

[v-menakakota]

Hi @jbora0494 ,

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @alish_b   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

Best Regards, 
Community Support Team 

[v-menakakota]

Hi @jbora0494  ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

Best Regards, 
Community Support Team