Forum Discussion

maflingo's avatar
maflingo
Regular Visitor
1 year ago

How to indirectly filter visual?

Hi,

I have a visual that shows the Visits per Company. When I select a certain Company in a slicer, I want the visual to only show the copmanies that have the same value in the field Peer Group as the selected Company.

I've tried building measures with SELECTEDVALUE and editing the interactions of slicers and the visual, but the visual always just shows all the companies.
The fields Copmany, Visits and Peer Group are all from the same table Startups.

Does anybody know how this could be achieved? Thank you!

Need Help

5 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    1 year ago

    Hello maflingo 

     

    Add this measure to your visual.

    FilteredVisits =

    VAR SelectedPeerGroup = SELECTEDVALUE(Startups[Peer Group])

     

    RETURN

    CALCULATE(

        SUM(Startups[Visits]),

        FILTER(

            Startups,

            Startups[Peer Group] = SelectedPeerGroup

        )

    )

    Ensure the slicer is filtering only the Company field.

    The measure will dynamically adjust the visual to show only companies in the same Peer Group as the selected one.

     

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos, it would be greatly appreciated.

     

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi maflingo,

    Thank you for using Microsoft Fabric Community and Thank you pankajnamekar25 for your response.

     

    May i know is your Issue Been Resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

    If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

     

    Thank you.

    • v-sgandrathi's avatar
      v-sgandrathi
      Community Support
      1 year ago

      Hi maflingo,
      we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

      If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

      Should you have any further questions, feel free to reach out.
      Thank you for being a part of the Microsoft Fabric Community Forum!

      • v-sgandrathi's avatar
        v-sgandrathi
        Community Support
        1 year ago

        Hi maflingo,


        we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

        If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

        Should you have any further questions, feel free to reach out.


        Thank you for being a part of the Microsoft Fabric Community Forum!