Dynamic title Field Parameters

[ClaraBcn]

Hello! I'm using field parameters to allow the users to dynamically switch among different scenarios (meaning: actual, forecast, budget, prior year, etc...) and compare them against each other;

I'm using two field parameters with same availability of scenarios. Then I bring in 2 slicers where I include this two field parameters. As a result the user is able to compare dynamically A24 vs B24 for instance or whatever comparison he/she wants to do. 

The issue comes with the measures for comparison between these two scenarios (field parameters). What I need is a measure which is changing the name dynamically depending on the user selection on the two slicers/field parameters. 

As I know measures have static names, I tried using field parameters again to be able to have a dynamic title for the comparison. Wanted result - if the user select A24 and B24 then the comparison title needs to be A24 vs B24, if the selection is A23 and T1 then comparison title needs to be A23 vs T1. 

Out of the field parameter I'm able to use SELECTCOLUMNS OR MAX to bring in the SELECTEDVALUE from Field Parameters. However, when I insert the MAX into the field parameter another value (not selected) comes in.

vs Comp 1 (abs) = {("vs"&[Max Main], NAMEOF('DB'[Main vs Comp 1 (abs)]))}

Does anybody faced a similar issue?

I've researched and seems not to be a solution for this one. Would another approach wtith 0 mainteinance regarding measures (new scenarios coming all the time) work besides this one?

Thanks a lot in advance!

[Anonymous]

Hi, @ClaraBcn 

According to your description, you want to implement dynamic headings based on what the slicer selects, and in the scenario you describe, the following simple approach might fit your needs
Create a VS column in the data table with the name VS, but the content is empty, add the column between A24 and T1 to realize the effect like "A24 vs B24". If that doesn't suit your needs, you can share a pbix file of your current progress without sensitive data for testing purposes.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[ClaraBcn]

Hello,

Thanks for your answer. 

My DB is not organized as such, I mean, I do not have different columns for each scenario but I have a column with the scenario name and a column with data. Example:

Scenario  Amount

A23         100

A22         5

A21         6

B23         40

B24         30

Moreover I need this title to be displayed in a table for instance, a text box would work better I believe. Because I need three columns to see A24 vs A23 a more over I don't get to see the difference but absolute values..

[amitchandak]

@ClaraBcn, As the table names and column names are static in nature, it can work based on today etc. But not based on the selected value

[ClaraBcn]

OK thanks for your answer! And is this possible using another approach?