Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
1 year ago

Parameter switch

Hello, i have a parameter which switches between two Metrcs totals, received and closues.

i am unable to get this to fit into a dynamic title which shows the total counts.

 

is there a method to output the counts in a title when I switch between parameters

 

currently I have tried

 

Title - Total Demand = "Total Demand | " & format(SUM('PR- Demand Reveived & Closure Switch'[Demand Reveived & Closure Switch]), "#,##")
Need Help

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    1 year ago

    hi NewbieJono ,

     

    could you paste some sample data for this column:

    'PR- Demand Reveived & Closure Switch'[Demand Reveived & Closure Switch]

  • NewbieJono's avatar
    NewbieJono
    Post Partisan
    1 year ago

    when i drag the parameter field onto the canvas it displays the number. but I am unable to wrap it in some text for a dynamic title

     

     

    displays as expected 

     

    but I would like to show Total Recived - [Parameter Result] as a dynamic ttitle

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, NewbieJono 

    Thanks for FreemanZ's reply. In the case of dynamic titles, you can customize the title under the Title of the corresponding visual object. By the way, I think you misunderstood FreemanZ , he wanted you to share some non-sensitive data for modeling out your field parameters and then test.

     



    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