Forum Discussion
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 can dynamically select Scenario From and Scenario To from related slicers and then via appropriate measures a matrix visual is populated as follows:
I would like a simple way to replace the static headers NSV-1 and NSV with what selected in the slicers so in my case: FY23_BDG1 and FY23_ACT respectively.
I have created a disconnected table:
aiming to have one line per each header in the matrix but I don’t know how to populate it with selected scenarios (where enhanced).
Is this possible?
Many thanks in advance.
2 Replies
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.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.