Change Field Parameter Names based on slicer selection

[sandyn-2303]

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

[v-yiruan-msft]

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]

Hi @v-yiruan-msft 

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

[v-yiruan-msft]

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

[sandyn-2303 · Accepted solution]

Hello @v-yiruan-msft ,

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

[v-yiruan-msft]

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