Dynamic Column Names in a table
Column names must be dynamic i.e. we should be able to change the column names in a Table/Matrix
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"
Darren Gosbell commented
@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.
A work around world be to use measures and a card
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.
Hi Sahil, Did you got any break through on Dynamic Column Names. Please share.