Update slicer selection based on visual selection

[baronraghu]

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
Florida	CVX	C	289
Idaho	CVX	C	223
Idaho	XOM	B	485
Wisconsin	MCD	B	190
Wisconsin	MCD	A	133
Idaho	MCD	A	271
Idaho	KFC	C	415
Florida	MCD	A	275
Florida	KFC	D	151
Florida	CVX	D	197
Texas	KFC	D	118
Wisconsin	KFC	D	476
Wisconsin	MCD	D	150
Texas	CVX	A	250
Florida	XOM	D	466

I have the following visuals

• a pie chart which shows the state split based on total values
• a doughnut chart which shows company split by the total value
• A Slicer which has the name of all the Fields

What I am looking for is when I select a field in pie chart (suppose- Florida) then I should simultaneously be able to select a company (say CVX). Based on my visual level selections the value in the slicer should also change. The slicer should only show me the fields available for CVX in Florida not all.

While creating the relationship I have set the cross filer direction to both but still isint helpful

Could you please help me on this.

[v-juanli-msft]

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]

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 · Accepted solution]

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