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

GeraldGEmerick's avatar
GeraldGEmerick
Super User
8 months ago

ADH_24 This can be a bit tricky since visuals do not actually interact with other visuals until you actually select something in the visual. Therefore, you could create a measure like:

Measure = MAX( 'Table'[Semester] )

Putting this in 2 card visuals and if you do the correct Edit interactions, this still will not work having only a filter on the graph as this filter does not propogate to the other visual (card) until you actually select something in the graph visual. 

 

One thing you could do would be to have 2 card visuals and just manually put the same filter on those visuals. Otherwise, you would likely need to go back to the slicer solution and use Edit interactions appropriately between the two sets of 3 visuals ( slicer, graph, card ). You could hide the slicer visuals on the page.