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...
jaktony's avatar
jaktony
Helper I
1 year ago

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"




  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

    • jaktony's avatar
      jaktony
      Helper I
      1 year ago

      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 

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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