Forum Discussion

ClaraBcn's avatar
ClaraBcn
Frequent Visitor
2 years ago

Dynamic title Field Parameters

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; ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    ClaraBcn
    Frequent Visitor
    2 years ago

    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..