Forum Discussion

baronraghu's avatar
baronraghu
Helper III
8 years ago
Solved

Update slicer selection based on visual selection

Hi All, I am trying to create a connected dynamic slicer/visuals for the below table   State Company Field Values Wisconsin MCD C 146 Florida CVX A 175 ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi baronraghu

    Do you want the two visuals show the information: in pie chart shows the state (suppose- Florida), in doughnut chart shows company from the selected state(CVX from Florida) ?

    If so, you can Edit Interactions within the two visuals.

    Detailed steps:

    1. select pie chart
    2. click “Edit Interactions”
    3. select icons on the doughnut chart

    the first is to filter the companies of the selected state (all companies of Florida)

    the second is to reflect the proportion of each company of the selected state ( the dark green in the picture below shows the  proportion of company CVX in Florida)

    the third shows no change in doughnut chart when selecting the state in pie chart.

     

    Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi baronraghu,

As you said, you want:

  1. select a field in pie chart (suppose- Florida)
  2. select a company (say CVX) in doughnut chart
  3. after the two steps above, the slicer changes in this way: shows only the CVX in Florida field.
  4. Additionally, the slicer contains all fields of the table, and after the selection applied, the slicer shows a field and a certain value of this field.

Is my understanding right?

If it is, what must be noted is slicer selection can’t be changed by other visuals’ selection. It is supported when you select value in a slicer, other visuals will make a change.

 

If you have any question, feel free to ask me.

Best regards

Maggie

  • baronraghu's avatar
    baronraghu
    Helper III
    8 years ago

    Hi Maggie,

     

    Yes your understanding is correct. Thanks for making it simple and easy to understand.

     

    So is there any way where section of two different visuals are selected. Like i said earlier I select (Florida) in the pie chart and simultaneously i select CVX from company.

     

    Regards

    Raghu

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      8 years ago

      Hi baronraghu

      Do you want the two visuals show the information: in pie chart shows the state (suppose- Florida), in doughnut chart shows company from the selected state(CVX from Florida) ?

      If so, you can Edit Interactions within the two visuals.

      Detailed steps:

      1. select pie chart
      2. click “Edit Interactions”
      3. select icons on the doughnut chart

      the first is to filter the companies of the selected state (all companies of Florida)

      the second is to reflect the proportion of each company of the selected state ( the dark green in the picture below shows the  proportion of company CVX in Florida)

      the third shows no change in doughnut chart when selecting the state in pie chart.

       

      Regards

      Maggie