Forum Discussion
Dynamic column name from its value
Watch this video in which "Source" is the name of the previous step in my query.
Unfortunately, while typing, it jumped from the second line to the first line, but it is the same "Source".
Watch this video in which "Source" is the name of the previous step in my query.
Unfortunately, while typing, it jumped from the second line to the first line, but it is the same "Source".
Thanks, that video makes much more sense!
Would there be a way to utilize a Switch or IF function for the name based on a slicer? Hypothetically, if I had a slicer based on Seasons of the year, I would want my columns to reflect the names of the month in that season.
My knowledge is specifically with Power Query.
Otherwise I think you need to clarify your question for DAX/Report experts.
Typically a slicer is used to select data from table rows, not from columns.
So it sounds like a strange request to me, but if you think something should be possible, I think you'd better start a new topic.
Hi pager,
Would there be a way to utilize a Switch or IF function for the name based on a slicer? Hypothetically, if I had a slicer based on Seasons of the year, I would want my columns to reflect the names of the month in that season.
As far as I know, it is not possible to do it currently. :smileyhappy:
Regards
hi Pager .
i am exactly looking for this solution. when i select a month from slicer , i want to see my meaure "revenue" with the month name from slicer. something like "revenue June 2018 ".
were you able to get this working? if so please share?
Absolut same issue - would be good to have a solution in here.
In my example we can switch in a slicer between Money and Volumes. So if user is selection Money in column names should be (EUR) and if selected volumes it should be written (HL)....
