Dynamically build matrix headers

[Anonymous]

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.

[Anonymous]

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]

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.