18 Comments
- Hi Sahil, Did you got any break through on Dynamic Column Names. Please share.
SebastianAdvocate III
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.- A work around world be to use measures and a card
- '@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.
- 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"
- 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.
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-501ac5248c93
- https://ideas.powerbi.com/ideas/idea/?ideaid=6b80e7fb-8faa-ec11-826d-281878e63983
- https://ideas.powerbi.com/ideas/idea/?ideaid=08c32d62-5fba-eb11-89ee-281878de0321
- (likely more)
Yes, this function is simple yet very useful.
For example, if we choose a Year "2022" in a slicer, then the column name shall be something like "2022 Actual Sales".
If 2021 is selected, then the column name shall be displayed as "2021 Actual Sales".
This functionality is so simple but add a lot of clarity for users.
We have some "user defined" fields in our system with names "udf1", "udf2" etc and we give the ability to each customer to configure the "udf" fields names i.e. "Test Column1 Name", "Test Column1 Name" etc
When those fields appear in the PowerBI report we need them to appear with each customer's configuration names instead of "udf1", "udf2"
Very very useful feature!!
6 years later, still not possible to use selection as column names while qlik had this since 2011.
I prefer pbi in every way but this and absolutely need it for work as I need to be clear to the business about the years, weeks etc instead of current week, last week ...
It's such a simple idea, logical to use but so hard to actually use. You can use current date and calculating from now this year month etc, but when selecting previous years its not yet possible..
Please add this❤️
