Forum Discussion
Change Field Parameter Names based on slicer selection
Hello Anonymous ,
Thanks for responding. I found a solution which I felt is best suitable for the current requirement.
- Created a parameter table for each of the measure
- Modified the parameter to repeat for 12 months and gave it a custom name as needed for each month.
- Created relationship from each parameter table to the Calendar table Month column
- Added Parameter fields from each Parameter table in a matrix, that way when I selected the month from slicer, custom column names are applied
- Sandy
Hi sandyn-2303 ,
It seems like you are trying to create dynamic column names in a Power BI matrix based on slicer selections. Base on my research, there is no option or property to get it. Could you please share your simiplified pbix file(exclude sensitive data) with us? Later we can check if there is any alternative to achieve it. Maybe use measure + card visual or other method...
Solved: Dynamic Column Names for Matrix Visual using Slice... - Microsoft Fabric Community
Solved: Power BI - Dynamically Change Column Name - Microsoft Fabric Community
Best Regards
Hello Anonymous ,
Thanks for responding. I found a solution which I felt is best suitable for the current requirement.
- Created a parameter table for each of the measure
- Modified the parameter to repeat for 12 months and gave it a custom name as needed for each month.
- Created relationship from each parameter table to the Calendar table Month column
- Added Parameter fields from each Parameter table in a matrix, that way when I selected the month from slicer, custom column names are applied
- Sandy
Hi sandyn-2303 ,
It's glad to hear that you got the solution. And thanks for sharing the solution here. It would be very helpful for the others in the community when they have the similar requirement as yours. Much appreciated!
Best Regards