Forum Discussion
static Column Header for columns
- Anonymous3 years ago
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
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