Forum Discussion

davidson929's avatar
davidson929
Regular Visitor
9 years ago

Pared down graph view based on filter

Hello,

 

I would like to know if this is possible. I have a bar graph and a pie chart. When you select an item on the pie chart the relationship view in the bar graph changes to relfect the relationship to the selected data in the pie chart. However, the bar chart has many data points. All the unrelated data points are just made more transparent instead of being removed from the view. 

 

Is there a way to not display information in a chart that is being filtered by related data in another chart? This would be great because then you wouldn't have to use the slider bar to scroll down to the remaining data that was relationally still relevent.

 

Thank you.

Tips and Tricks

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago
    Hi davidson929,

    In the Power BI Desktop select modeling option in the ribbon, then select interactions (1st button) when you do that if you select one chart the others are highligted and there are a few options that show, chosd the filter to use your chart as a slicer.

    Regards

    Mfelix
  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi davidson929,

    Based on my understanding, I create a example and test.

    1. Create the bar chart and pie chart using same fields. When we select one filed one chart, it will highlighted in another table, while other are still exist invisual, they are not removed.



    2. Create the bar chart and pie chart using fields come from different tables. But there is a relationship between. It display the same result when I select one value in chart.



    I am still confusing your scenario, what's the mean of "All the unrelated data points are just made more transparent instead of being removed from the view" Could you please share more details or .pbix file for analysis.

    Best Regards,
    Angelia

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    Hi davidson929,

     

    I don't know if you have already solved this but as you can see below if you do the following you will have what you need:

    1 - Choose chart

    2 - Format bar

    3 - Edit Interactions

    4 - On the other visuals in the page you will have options to change the interactivity in the charts - Filter; Highlight (default); None

     

    Please check the print below, as you can see how image 3 after chosing the filter the bart chart only shows the value of the select values in the pie chart the others are removed.

     

     

    Regards,

     

    MFelix

     

     

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi davidson929,

      Have you resolved your problem? If you have, in order to help more people can find workwroud form here, please mark the helpful reply as answer. Thanks for understanding.

      Best Regards,
      Angelia