Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Interaction between Pie chart and Combo chart

Hello everyone,

 

I am new to Power BI Desktop and I want to specify the interaction between Combo chart and Pie chart in way that when I choose a pie section, it filters the Combo chart “columns” and leaves the “line” as it was before.

Which means that I want the filter to be applied only to the columns.

 

Thank you.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous -

    One possibility is to layer a line chart on top of a column chart.

    Cheers!

    Nathan

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

     

     

    Hi Anonymous, thanks, I've thought about to layer a line chart on top of a column chart, but I've faced the problem of showing information in "tooltip" for the two charts.

    Sorry v-frfei-msft, data contains confidential information, but you can see in the images below problem that I want to solve. The first image is before the filer application, the second is after, but it's changing the line which I want to stay the same as in the first chart.

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello v-frfei-msft ,

      This is not what I'm searching for. It's working on both column and line, you can read again my request (I think It's clear).