Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamically build matrix headers

Hi all,   in my sales analysis report I have two slicers selecting user desired scenarios:   Each slicer is referencing to two disconnected tables looking like this:   The user ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Since I don't know what your specific data model looks like, I can only offer suggestions rather than specific solutions:
You can try to create a parameter, then put the parameter into the matrix.
Or you can try the solution in this post of the Message 3:
Solved: Dynamic column header in Matrix - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ok Anonymous , unfortunately that is not my use case as my dynamic column names are not related to dates but rather to scenarios. I will need therefore to create a temporary table where to put the headers and the related measures and then hope that everything is working. I hace watched lot of video on dynamic matrix headers but noone is based on dynamic column names different from dates.

 

Thanks anyway - if I find a way I will let you know.

 

Regards,

C.