Forum Discussion

mohammedismail's avatar
5 years ago
Solved

Highlight Visual/Table when filtered

Hi,

 

I have various charts and Tables on a page - Some of the Visuals are connected (They filter when a value is selected in another table/visual) and some arent. When I click on a particular row of a table I want to highlight all the visuals in the page which are affected by that filter. Can someone help me out please ?

 

Thanks

Ismail

  • Hi mohammedismail 

    To supplement Anonymous 's reply, the default interaction behavior in a report is cross-highlighting unless you change the option in Power BI Desktop Options.

    What's more, not all visuals support to be cross-filtered or cross-highlighted by other visuals. For example, slicer can only filter other visuals and be filtered by other visuals. Table can filter or highlight some other visuals, but it cannot highlight slicer. The types of interaction that a visual supports depend on its type and the types of other visuals used to influence it.

    To change the interaction type of a visual, select the visual, click Format > Edit interactions and select the corresponding icon in upper right corner of other visuals.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello mohammedismail ,

     

    selecting a row in or data in 1 visual that automatically hightlights the related data in another visual.

    and filetring the data using slicer filters all the visual in that page if it contains related data.

     

    You can also edit the interactions between the visuals.

     

    Please refer the link for more info:

    https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-filters-and-highlighting

    https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support

    Hi mohammedismail 

    To supplement Anonymous 's reply, the default interaction behavior in a report is cross-highlighting unless you change the option in Power BI Desktop Options.

    What's more, not all visuals support to be cross-filtered or cross-highlighted by other visuals. For example, slicer can only filter other visuals and be filtered by other visuals. Table can filter or highlight some other visuals, but it cannot highlight slicer. The types of interaction that a visual supports depend on its type and the types of other visuals used to influence it.

    To change the interaction type of a visual, select the visual, click Format > Edit interactions and select the corresponding icon in upper right corner of other visuals.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.