topic Re: Dynamic Column Headers depending on a Slicer selection in DAX Commands and Tips

Dynamic Column Headers depending on a Slicer selection

ChaimaeZd — Wed, 28 Dec 2022 12:12:52 GMT

I have a question , is there any way to make the column names in a Matrix/Table dynamic and depending on a slicer selection ?

I tried to solve this with field parameters but the name argument in the field parameter formula can't read the slicer selection ( The SELECTVALUE function does not allow to change the name , it returns blank .

Could you please suggest a solution within field parameters or any other method.

Thank You in advance ,

Chaimae

Re: Dynamic Column Headers depending on a Slicer selection

Omar789 — Wed, 28 Dec 2022 12:15:00 GMT

Hello

I have a same request, when i choose an item in a slicer, the field parameter name returns blank, my objective is to make the column headers (names) dynamic and not fix

thanks

Re: Dynamic Column Headers depending on a Slicer selection

FreemanZ — Wed, 28 Dec 2022 13:07:52 GMT

hi ChaimaeZd

Just noticed there is a similar post and please check my proposal works.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-column-headers-in-matrix/m-p/2991125#M100646