topic Re: Dynamic Column Header based on Filter from another field in DAX Commands and Tips

Dynamic Column Header based on Filter from another field

jaktony — Thu, 09 Jan 2025 19:23:58 GMT

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 to select from actuals to budget to forecast. When I bring down the data in a matrix, I want to be able to switch the column header so when Alpha is set to "Act", the column will say "Act" instead of "Alpha_all" (this is a calculated measure). I tried using field parameters but haven't had much luck.

Re: Dynamic Column Header based on Filter from another field

Anonymous — Fri, 10 Jan 2025 06:02:43 GMT

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.

Re: Dynamic Column Header based on Filter from another field

jaktony — Fri, 10 Jan 2025 18:02:42 GMT

Thank you for the reply Anonymous , however each Scenario name should have its own selection rather than selection driving all scenario name.

For example,

Alpha = Act
Beta = Bud
Gamma = Forecast

In your suggestion, if the selector is set to "Actual" - all scenario's (Alpha, Beta, and Gamma) will be set to "Actual"

Re: Dynamic Column Header based on Filter from another field

Anonymous — Mon, 13 Jan 2025 09:30:16 GMT

Hi,

Try to create the following table. Adding the relationship between new table and scenarios table.

Measure = SWITCH(MAX('Table'[TableHeaders]), "Actual",[Actual], "Budget",[Budget], "PY Actual",[PY Actual] )

If it still doesn't work, please provide sample data.

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.

Re: Dynamic Column Header based on Filter from another field

jaktony — Mon, 13 Jan 2025 14:38:51 GMT

Thank you again for your reply. I have attached a sample data file replicating my main file. Please let me know if you have questions.

PBI Test File

Re: Dynamic Column Header based on Filter from another field

Anonymous — Tue, 14 Jan 2025 01:25:36 GMT

Hi,

I can't open the download URL, it requires permissions, you share it in a different way and don't set authentication.

Best Regards,

Wisdom Wu

Re: Dynamic Column Header based on Filter from another field

jaktony — Tue, 21 Jan 2025 17:48:54 GMT

Hi Anonymous ,

Sorry for the late reply. Can you check and see if you get access to the link below? Thanks

https://drive.google.com/drive/folders/1uOwmy9uOYTu0FA2-6fgIMs_CE3rB90pD?usp=sharing

Re: Dynamic Column Header based on Filter from another field

Anonymous — Wed, 22 Jan 2025 08:39:44 GMT

Hi,

Are you providing a template? This one has to be opened by entering a string.

You can view the following links to learn more information.

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

Solved: Dynamic Column Names for Matrix Visual using Slice... - 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.

Re: Dynamic Column Header based on Filter from another field

jaktony — Wed, 22 Jan 2025 20:34:22 GMT

Sorry provided the wrong file. I don't have the level of access on here to directly give link to my test file. Please see the link below to the updated test file and let me know your thoughts.

https://drive.google.com/drive/folders/1uOwmy9uOYTu0FA2-6fgIMs_CE3rB90pD?usp=sharing

Re: Dynamic Column Header based on Filter from another field

jaktony — Tue, 28 Jan 2025 13:14:22 GMT

Anonymous Hi any luck accessing the new file and testing?

Re: Dynamic Column Header based on Filter from another field

Anonymous — Thu, 06 Feb 2025 06:24:59 GMT

Hi ,

Based on the testing, drag the Alpha Scenario Name to the matrix columns.

Then, select the slicer is shown below.

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.

Re: Dynamic Column Header based on Filter from another field

jaktony — Tue, 11 Feb 2025 19:35:38 GMT

Anonymous thank you for your reply. I had tried that a while ago but had no luck. With multiple scenarios on the matrix, this is what it would look like: