Sahil Bansal on 06 Apr 2017 18:21:20
Column names must be dynamic i.e. we should be able to change the column names in a Table/Matrix
- Comments (17)
RE: Dynamic Column Names in a table
This seems to be important for many, there are already a bunch of similar/duplicated ideas:https://ideas.powerbi.com/ideas/idea/?ideaid=cbf46865-22e7-ec11-b5cf-501ac5248c93https://ideas.powerbi.com/ideas/idea/?ideaid=6b80e7fb-8faa-ec11-826d-281878e63983https://ideas.powerbi.com/ideas/idea/?ideaid=08c32d62-5fba-eb11-89ee-281878de0321(likely more)
RE: Dynamic Column Names in a table
A dynamic column name would be necessary not just for matrix, but with plain tables, where the column values could be dictated by a slicer selection and the column would be nice to have a specific name based on that selection.
RE: Dynamic Column Names in a table
I tried to put a card on top of the table, but it doesn't work on mobile visualization. We NEED this! Calling a column "Actual year" is not as attractive as calling it "2019"
RE: Dynamic Column Names in a table
'@Sebastian, you can achieve your required output today by putting the year attribute on the columns then changing the measure expression to the following
= calculate(sum(value); FILTER(VALUES('Date'[Year]), 'Date'[Year] = year(today () )-2))
This measure will only return a value against the current year, it will return blanks against any other year which Power BI will automatically filter out.
RE: Dynamic Column Names in a table
A work around world be to use measures and a card
RE: Dynamic Column Names in a table
We would also need this.
For example you calculate a value for a special year with the following measure
name = calculate(sum(value); year(date) = year(today () )-2)
It would be nice if the column name would be the year of the value which is calculated by the measure.
RE: Dynamic Column Names in a table
Hi Sahil, Did you got any break through on Dynamic Column Names. Please share.