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