How to Control Visual Interaction from the Visuals

[dvnnnaidu]

Hi,

I have four bar charts in a Report page, all are realted. Interaction type between them is filtering the data.

Now when I click on a value on one chart, all the other charts gets filter based on the selected value on the first chart.

This works fine.

But what i need is if we select the value in first chart, and then in the second chart which already got filtered , I want to select a value and expecting the last two charts to get filter based on the first chart selected value and also based on second chart selected value.

Where as what's happening is when we select a value in the second chart, first chart value gets deselected.

I have google and not found a solution for this , this looks to be the standard behaviour.

Can anyone help provide a solution for the requirement 

[parry2k]

@dvnnnaidu you have to use ctrl when you do the 2nd selection and it will keep the first selection.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[dvnnnaidu]

Dear @parry2k , thanks for answer.

I have tried CTRL+ selection of values in the second chart, but had no luck.

It still deselects the value from the first chart

[v-easonf-msft]

Hi , @dvnnnaidu 

Through  the workaround  mentioned  by @parry2k  , I can achieve a good effect, and keep their status with bookmarks.

You can refer to my sample file.

pbix attached

Bookmark1： it shows COGS, Profit of  Paseo,VTT,velo  in USA,Canada,France

Bookmark2: it shows COGS, Profit of  Velo,Amarilla in USA,Mexico

Best Regards,
Community Support Team _ Eason

[dvnnnaidu]

hi @v-easonf-msft , thank you for your demo using bar charts.

For all the reports where I have used the standard visulas it looks to be working fine.

But same is not working properly with Custom visuals, I have used Bullet Chart by OKviz and also "Funnel with Source by MAQ Software".

With these two charts I am not able to replicate the same functionality.

Do you suggest me to raise this as a bug?

Thank you,

Narasimha Naidu

[parry2k]

@dvnnnaidu for custom visuals, you should reach out to the developer directly.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@dvnnnaidu works for me, what power bi version you are using.

in below screenshot I have selection from two visuals using ctrl+

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[dvnnnaidu]

@parry2k , thanks for the update the on the solution.

I have treid this with the regular bar charts which and it's working as you have explained.

In the reports where I have bar charts I have treid this and it's working perfectly.

But in one of my report which I have developed I have used "Bullet Chart by OKViz". With this chart CTRL+ is not working.

But in general thank you for your solution