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 (6)
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.