https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Column-Headers-with-Dates/m-p/4036700#M10151 <P>For some reason I can't find the way to change the name of a column in a table or matrix dynamically. I can change the table title with a function, but not the column names.<BR /><BR />I have a table (or matrix) with measures as the columns:<BR />Column 1 is current month; Column 2 is previous month; Column 3 is the difference between Cols 1 and 2; Column 4 is 12 months ago; Column 5 is the 12 month average.<BR /><BR />I want the names of the columns to change each month. So they would say:<BR />Jul 24; Jun 24; Month Change; Jul 23; Aug 23-Jul 24 Average.<BR /><BR />Obviously, next month they would say:<BR />Aug 24; Jul 24; Month Change; Aug 23; Sep 23-Aug 24 Average.<BR /><BR />Other than sticking cards over every column name(!) how can I do this?<BR /><BR />Thank you</P> Thu, 11 Jul 2024 09:09:15 GMT GE1 2024-07-11T09:09:15Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Column-Headers-with-Dates/m-p/4036700#M10151 <P>For some reason I can't find the way to change the name of a column in a table or matrix dynamically. I can change the table title with a function, but not the column names.<BR /><BR />I have a table (or matrix) with measures as the columns:<BR />Column 1 is current month; Column 2 is previous month; Column 3 is the difference between Cols 1 and 2; Column 4 is 12 months ago; Column 5 is the 12 month average.<BR /><BR />I want the names of the columns to change each month. So they would say:<BR />Jul 24; Jun 24; Month Change; Jul 23; Aug 23-Jul 24 Average.<BR /><BR />Obviously, next month they would say:<BR />Aug 24; Jul 24; Month Change; Aug 23; Sep 23-Aug 24 Average.<BR /><BR />Other than sticking cards over every column name(!) how can I do this?<BR /><BR />Thank you</P> Thu, 11 Jul 2024 09:09:15 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Column-Headers-with-Dates/m-p/4036700#M10151 GE1 2024-07-11T09:09:15Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Column-Headers-with-Dates/m-p/4038018#M10158 <P>You will need to use a calculated table to generate these column names during each semantic model refresh.</P> Thu, 11 Jul 2024 20:26:58 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Dynamic-Column-Headers-with-Dates/m-p/4038018#M10158 lbendlin 2024-07-11T20:26:58Z