Forum Discussion

jaktony's avatar
jaktony
Helper I
1 year ago

Dynamic Column Header based on Filter from another field

Hi I'm stuck figuring out how to change column headers in a table/matrix for a dynamic field that is filtered by scenario.   I have 3 filtered fields: Alpha, Beta, Gamma. These fields allow users t...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jaktony ,

Based on the testing, create the new table as bridge.

Then, creating the new measure to filter.

Dynamic column headers = SWITCH(MAX('Selected Table'[TableHeaders]),
                "Actual",[Actual],
                "Budget",[Budget],
                "PY Actual",[PY Actual]
                )

The result is shown below.

You can also view the following link to learn more information.

Solved: Dynamic Column Names for Matrix Visual using Slice... - Microsoft Fabric Community

Solved: Dynamically changing matrix column headers based o... - Microsoft Fabric Community

Solved: How to create dynamic column headers & custom cond... - Microsoft Fabric Community

 

Best Regards,

Wisdom Wu

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