Forum Discussion

ADH_24's avatar
ADH_24
New Member
8 months ago
Solved

Display selected filter on this visual value per individual graph.

I created a page that displays the same graph 2X so the consumer can pick a time period for one graph and another for the other graph to compare top programs for different time periods. At first I cr...
  • Olufemi7's avatar
    8 months ago

    Hi ADH_24

     

    You can display the selected filter value for each individual visual by creating a simple DAX measure that reflects the filter context. That way, a card or dynamic title will always show the consumer’s choice without needing slicers.

     

    1. Create a Measure for the Selected Value

     

    Selected Semester =

    SELECTEDVALUE('Semester'[SemesterName], "No Semester Selected")

     

     

    • If one semester is chosen → it shows that semester.

    • If none or multiple are chosen → it shows “No Semester Selected” (you can change this text).

     

    2. Add a Card Visual Beside Each Graph

     

    • Insert a Card visual next to each graph.

    • Drop the `Selected Semester` measure into the card.

    • Because the card inherits the same filter context as the graph (when you use Filters on this visual), it will display the semester chosen for that specific graph.

     

    3. (Optional) Handle Multiple Selections

     

    Selected Semesters =

    CONCATENATEX(

        VALUES('Semester'[SemesterName]),

        'Semester'[SemesterName], ", ")

     

    This will list all selected semesters in the card.

     

    4. Alternative: Dynamic Titles

     

    Graph Title =

    "Enrolled Programs for " &

    SELECTEDVALUE('Semester'[SemesterName], "Selected Semester")

     

    Then go to the visual → Format → Title → fx (conditional formatting) → bind it to this measure.

    Each graph’s title will automatically show the selected semester.

     

    Example

     

    • Graph 1 filter: Semester = 1/2025 → Card shows “Semester 1/2025”

    • Graph 2 filter: Semester = 2/2025 → Card shows “Semester 2/2025”

     

     

    Now consumers can clearly compare side by side without cluttering the page with slicers.

     

     

     If this answered your question, please click “Accept as Solution” so others with the same issue can easily find it.