Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to dynamically change column field names ? (For: Google Analytics goal types)

Hello,   I am reporting some Google Analytics data, and I am struggling to dynamically change gol types (e.g: 1 and 2) into their corresponding conversion names at account level.   My objective i...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

AFAIK, current power bi does not support create dynamic calculated column/table based on filter/slicer effect.

If you mean dynamic change the visual titles, you can create a measure and setting the visual title based on expressions results.

Expression-based titles in Power BI Desktop - Power BI | Microsoft Docs

Notice: the data level of power bi.

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you for your help. But is not what I am looking for. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous,
      So you mean to group your records based on fields value and assign specific categories instead of change field names? If that is the case, you can try to use the following DAX formulas:

      Goal Types =
IF (
    'All Data'[Data Source] = "GA Main Website Accounts",
    SWITCH (
        'All Data'[Account],
        "Random1",
            IF (
                'All Data'[Goal 1] > 0,
                "Hero customer form submission",
                IF ( 'All Data'[Goal 2] > 0, "Product find out more CTA", "Other" )
            ),
        "Random2",
            IF (
                'All Data'[Goal 1] > 0,
                "Apply now CTA",
                IF ( 'All Data'[Goal 2] > 0, "Discover more CTA", "Other" )
            ),
        "Random3",
            IF (
                'All Data'[Goal 1] > 0,
                "Lead generation sign up form",
                IF ( 'All Data'[Goal 2] > 0, "Find your car CTA", "Other" )
            )
    )
)

      Regards,
      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thank you for your help,

         

        What I am trying to do is to amend the column goal name in the correct goal name. 

         

        For instance on Account Random1 Goal 1 in its native Google analytic account is called "Hero customer form Submission". Hence, I would like to assign the correct naming by type of goal number based on a specific Account. 


        Hope this make sense