Forum Discussion
Dynamic column names from measure returned from SWITCH()
Using a toggle for QoQ or YoY growth, I'm using a switch function to return either the QoQ growth or YoY growth rate and populate a matrix column with the respective growth rate.
I have the SWITCH() function working correctly where there's a table containing the respective QoQ or YoY options for the toggle box. The image below is for the toggle table.
What I can't seem to figure out is based on results of the switch function, how to have the column name be dynamic based on what's returned. Currently, regardless of the values populated in the measure using the switch function, the column name is just the name of the measure,
The measure itself is fairly simple
QTD Sales Toggle = SWITCH(SELECTEDVALUE(ToggleButton[KPI_No]), 1, [Sales QTD LY], 2, [Sales QTD LQ])4 Replies
- amitchandak
Super User
Grygger , I am assuming you want to change the measure display name. I doubt that is possible
Well it's really just the column heading that I'd like to change, is there anyway for that to be dynamic based on which measure is returned through the switch function? Or even just showing the name of the returned measure?
v-jingzhangCommunity Support
Hi Grygger
Currently Power BI doesn't support dynamic column names. You can vote up for these similar ideas:
Microsoft Idea · Dax calculated measure name / Dynamic column headers
Microsoft Idea · Need facility to change column name dynamically.
Microsoft Idea · Dynamic Column Names in a table
Best Regards,
Community Support Team _ JingThis can be done with the new field parameters feature. Create a new field parameter and add the measures that you would like to toggle between, keep the checkbox for "add slicer to page" enabled. Upon creation of the parameter you will get a new calculated table, one of the columns will be unhidden. Place that unhidden column on your matrix. Interacting with the slicer will change the measure, along with column header.
