Dynamic Title for Matrix by Field Parameters and Buttons

[sagarlothe85]

In one of the PowerBI visuals, I have a matrix (Bookmarks), a field parameter and a few buttons. I want the title of matrix should change dynamically if i select button and parameter both. How should i do it?

There are a few buttons, but there is no buttons table present and it is in the form of DAX measure, Also Parameters are :- Gender, Class Level, Nationality Category, Student Locality Region, Was in Virtual School, Level of Support

Buttons are :- Total Counts, Leaver Counts, Intake Counts, % Difference, % Leavers, % Intakes.

I want the title of the matrix should be :- Total Counts By Gender, Total Counts By Class Level, Leaver Counts by Gender, Leaver Counts By Class Level.... Like this

Buttons are already working fine, but i want to incorporate both Buttons and Field Parameters

How should i do it?

[v-mdharahman]

Hi @sagarlothe85,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you want to change matrix's title dynamically whenever you select button and parameter together. As @rohit1991 already responded to your query, please go through his response and mark it as solution if it answers your query.

I would also take a moment to thank @rohit1991 and @Deku, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[rohit1991 · Accepted solution]

Hi @sagarlothe85 ,

To create a dynamic title in your Power BI matrix that reflects both the selected field parameter (like Gender, Class Level, etc.) and the selected metric button (such as Total Counts, Leaver Counts, etc.), you can use a DAX measure that combines both selections into a single string.

Since your buttons are implemented using DAX measures and not from a disconnected table, you can define a measure that returns the name of the selected metric based on logic (like using ISSELECTEDMEASURE or a custom SWITCH statement).

Similarly, the field parameter table automatically generated by Power BI contains the selected field name, which you can retrieve using SELECTEDVALUE. You can then concatenate the metric name and field name in a new measure for example, Total Counts by Gender or % Leavers by Class Level. 

This measure can be applied as the matrix title by going to the visual’s title settings, selecting the fx (conditional formatting) option, and using the new dynamic title measure as the field value. This approach will ensure your matrix title updates in real time based on both the selected button and field parameter.

[sagarlothe85]

Below is the DAX for the same, as of now I have hardcoded the values, but want this to be dynamic.

MatrixTitle3 =

VAR SelectedParameter =

    SWITCH(

        SELECTEDVALUE('Table2 Parameter'[Parameter Fields]),

        "'DimGender'[Gender]", "Gender",

        "'DimClassLevel'[Class_Level]", "Class Level",

        "'DimNationalities'[Nationality_Category]", "Nationality Category",

        "'DimStudentLocalities'[Student_Locality_Region]", "Student Locality Region",

        "'Student Data (Yearly Student)'[Was_In_Virtual_School]", "Was in Virtual School",

        "'DimLevelofSupport'[Level_Of_Support]", "Level of Support",

        "Category"  -- Default value if nothing is selected

    )

RETURN

    "Intake Counts" & " by " & SelectedParameter

[v-mdharahman]

Hi @sagarlothe85.,

Just following up to your previous message, I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[Deku]

What are the buttons doing?

Can out share a image of what you are trying to do. Description is not clear