Forum Discussion

sandyn-2303's avatar
sandyn-2303
Frequent Visitor
1 year ago
Solved

Change Field Parameter Names based on slicer selection

Hello,

 

I have done a bit of searching but I couldnt find a solution or a workaround for this. Any help is much appreciated.

I have created a Field Parameter Table with multiple measures. Each measure has a logic to calculate the sales and profit based on the selected month, say logic for 1st month of a Quarter - Jan, Apr, Jul, Oct is different from logic to calculate for 2nd month of a Quarter and so on. Now, the challenge is, based on the month selected from the slicers, I want the column name in the matrix to change. That is, if I select Jan or Apr or Jul or Oct, I want the parameter name "Month1 of Qtr Act" to be changed dynamically. I tried the SELECTEDVALUE('Calendar'[MonthName]) which doesnt work on Parameter Tables. 

Parameter =
{
    ("Month1 of Qtr Act", NAMEOF('BPC_DAX'[Month_1_Q]), 0),
    ("Month2 of Qtr Act", NAMEOF('BPC_DAX'[Month_2_Q]), 1),
    ("Qtr_Implied", NAMEOF('BPC_DAX'[Qtr_Implied]), 2),
    ("Qtr_Estimated", NAMEOF('BPC_DAX'[Qtr_Estimated]), 3),
    ("Q1 Actuals", NAMEOF('BPC_DAX'[Q1_Actuals]), 4),
    ("Q2 Actuals", NAMEOF('BPC_DAX'[Q2_Actuals]), 5),
    ("Q3 Actuals", NAMEOF('BPC_DAX'[Q3_Actuals]), 6)
}

 

Thanks,

Sandy

 

datamodel
DAX
Field parameters
  • sandyn-2303's avatar
    sandyn-2303
    1 year ago

    Hello Anonymous ,

     

    Thanks for responding. I found a solution which I felt is best suitable for the current requirement.

    1. Created a parameter table for each of the measure
    2. Modified the parameter to repeat for 12 months and gave it a custom name as needed for each month.
    3. Created relationship from each parameter table to the Calendar table Month column
    4. 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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

    • sandyn-2303's avatar
      sandyn-2303
      Frequent Visitor
      1 year ago

      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