topic Re: Dynamically changing matrix column headers based on slicer value in DAX Commands and Tips

Dynamically changing matrix column headers based on slicer value

DanielBragg91 — Tue, 18 Apr 2023 12:12:04 GMT

I want to be able to display a matrix with and without some columns based on a slicer selection.

So far I've managed to create two field parameters "HeadersIncQuotes" and "HeadersExcQuotes" containing the headers I will need in each view. I've then tried to create a new calculated table that chooses between these two field parameters depending on a selected value but I'm running into errors:

Headers = SWITCH(SELECTEDVALUE(select_Quote[SelectQuote],"abc"),"Yes",CALCULATETABLE(HeadersIncQuotes),"No",CALCULATETABLE(HeadersExcQuotes))

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Am I on the right track here? Or is there a better way of doing this? I already explored using buttons and bookmarks to change the matrix displayed on my visual, but I want to go down the slicer route because the my slicer selection also feeds into some measure calculations and I don't want two separate selections to be made (one for the visualisation displayed and one for the measure calculations).

Thanks
Dan

Re: Dynamically changing matrix column headers based on slicer value

olgad — Tue, 18 Apr 2023 12:28:39 GMT

Hi, take a look at this article to see how i group columns under one field parameter to bring with one click the columns that i would like to display.
https://www.linkedin.com/pulse/field-parameters-case-measure-groups-olga-dontsova/?trackingId=wFMbN2zaSuC6YlrppL%2FSYw%3D%3D

Let me know if you have further questions.

Re: Dynamically changing matrix column headers based on slicer value

DanielBragg91 — Tue, 18 Apr 2023 14:19:43 GMT

That worked a treat! Thank you so much

Re: Dynamically changing matrix column headers based on slicer value

anushaghi123 — Wed, 24 Jan 2024 14:40:48 GMT

Hi,

Need help with Dynamic column header

I have attached the screenshot where have set of columns and created measure for all separate column.

When I select Month and Year it has to show same as screenshot.

Is there any way I can do it in Power BI desktop. Please let me know

Thanks