Reply
Member
Posts: 47
Registered: ‎01-11-2017
Accepted Solution

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

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.


Accepted Solutions
Highlighted
Community Support Team
Posts: 2,269
Registered: ‎03-15-2018

Re: Update slicer selection based on visual selection

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.

10.png

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

 

View solution in original post


All Replies
Community Support Team
Posts: 2,269
Registered: ‎03-15-2018

Re: Update slicer selection based on visual selection

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

Member
Posts: 47
Registered: ‎01-11-2017

Re: Update slicer selection based on visual selection

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

Highlighted
Community Support Team
Posts: 2,269
Registered: ‎03-15-2018

Re: Update slicer selection based on visual selection

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.

10.png

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