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 ,
If you choose the single selection in field parameter slicer, then you can get a dynamic tile by the following methods:
Method 1: Toggle on the option "Show summary" for field parameter slicer header
Method 2:
1. Create a measure as below to get the dynamic title
Dynamic Title = MIN('Dim_Parameter'[Dim_Parameter])2. Add a card visual for dynamic title
3. Align the field parameter slicer and the above card visual
Best Regards
Hi Anonymous
Thanks for your response. But I am looking for changing the name of the parameter used as columns within the matrix itself. For example, in the 1st matrix below, the parameter names are generic, Month_1_Q, Month_2_Q, Qtr_Implied. I want this to be dynamically renamed based on the Calendar Month selection from a slicer. In Jan, it should have Jan Actuals, Feb Actuals, Q1 Impled (as shown in 2nd matrix below) . In April, it should be Apr Actuals, May Actuals, Q2 Implied etc. After 6 months, I will have to add a FY Expected measure as well in the matrix which is also part of the paramter table that I would be creating.
Thanks,
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