Forum Discussion
static Column Header for columns
Hi team,
i have the below requirment. The user needs a static header for some columns of TABLE vizualization as below. is there a way to achive it? please help.
if i add a label on top of the columns.. the alignment changes when the table scroll happens.
Please help.. This is TABLE vizualization
Hi ak77 ,
I created some data:
Sorry, according to the research, it is not possible to add a column as a header above the table Visual, your data column exists at the top, this is due to the design of Power BI.
You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Or you can consider using a matrix, but this may require a change in the form of the data.
Here are the steps you can follow：
1. In Power Query -- Add Column – Index Column – From 1.
2. Select [1 Year] … [C] – Transform – Unpivot column.
Result:
3. Create calculated table.
Flag = var _table1= FILTER( 'Table','Table'[Attribute] IN {"1 Year","2 Year","3 Year","4 Year","5 Year"}) var _table2= ADDCOLUMNS( _table1,"Group","Annulaized Years") var _table3= FILTER( 'Table',NOT('Table'[Attribute]) IN {"1 Year","2 Year","3 Year","4 Year","5 Year"}) var _table4= ADDCOLUMNS( _table3,"Group",BLANK()) return UNION( _table2,_table4)4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi ak77 ,
I created some data:
Sorry, according to the research, it is not possible to add a column as a header above the table Visual, your data column exists at the top, this is due to the design of Power BI.
You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Or you can consider using a matrix, but this may require a change in the form of the data.
Here are the steps you can follow：
1. In Power Query -- Add Column – Index Column – From 1.
2. Select [1 Year] … [C] – Transform – Unpivot column.
Result:
3. Create calculated table.
Flag = var _table1= FILTER( 'Table','Table'[Attribute] IN {"1 Year","2 Year","3 Year","4 Year","5 Year"}) var _table2= ADDCOLUMNS( _table1,"Group","Annulaized Years") var _table3= FILTER( 'Table',NOT('Table'[Attribute]) IN {"1 Year","2 Year","3 Year","4 Year","5 Year"}) var _table4= ADDCOLUMNS( _table3,"Group",BLANK()) return UNION( _table2,_table4)4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly