Forum Discussion

dia612's avatar
dia612
Helper IV
6 years ago
Solved

Dynamically changing name ofthe column header

Hello, In Power BI, We can dynamically change the title name  using measure in Format > Title > fx But is there a way , I can change name of the column Header also  dynamically using the measure??...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi dia612,

    It means you can create a list with the column names you wanted, then you can invoke them in your query table with 'renamecolumns' function to dynamic rename current column names:

    Columnname stored a list of column names strings

    let
    Source = {"id","name","desc"}
in
    Source

    Query table invokes above list to rename fields:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRU0lEyMgISxsZKsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", Int64.Type}, {"Column3", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",List.Zip({Table.ColumnNames(#"Changed Type"),ColumnNames}))
in
    #"Renamed Columns"

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI dia612,

You can try to create a list with column names and invoke it in query table steps to dynamic rename your columns on the query editor side.

>>But is there a way , I can change name of the column Header also  dynamically using the measure??

Nope, measure formulas impossible to interact with data model fields dynamically. (its source are generated from data model tables, you can't use child level to effect its parent)

Regards,

Xiaoxin Sheng

  • dia612's avatar
    dia612
    Helper IV
    6 years ago

    Hello Anonymous ,

     

    Thankyou for taking time for replying.

    I did not understand your suggestion clearly

    "You can try to create a list with column names and invoke it in query table steps to dynamic rename your columns on the query editor side"

     

    Could you please explain it with example

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi dia612,

      It means you can create a list with the column names you wanted, then you can invoke them in your query table with 'renamecolumns' function to dynamic rename current column names:

      Columnname stored a list of column names strings

      let
    Source = {"id","name","desc"}
in
    Source

      Query table invokes above list to rename fields:

      let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRU0lEyMgISxsZKsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", Int64.Type}, {"Column3", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",List.Zip({Table.ColumnNames(#"Changed Type"),ColumnNames}))
in
    #"Renamed Columns"

      Regards,

      Xiaoxin Sheng