Select a data point in a visual

[louisvp]

Dear Community,

Is it possible , when you mark a data point in a visual by clicking on the data point in the visual, that the other visuals on that page shows the whole bar (i.e. in a bar chart) instead of a small part of the bar highlighted with the selected part of the data in the first visual?

For example in the first visual the Sales amount of 3 product groups are shown and in the second visual the Sales amount per year 2016, 2017 and 2018 are shown.

When I select 2017 in the second visual, the first visual still shows the Sales amount of 3 product groups in total (lightly shadowed) and highlighted the 2017 Sales amount per product group.

What I want to do is i.e. select the year 2017 in the second visual and that the first visual only shows the 2017 Sales amount of 3 product groups without the Sales amount of 3 product groups of 2016, 2017 and 2018.

I hope someone of you is able to help me.

Kind regards.

Louis van Paassen

[louisvp · Accepted solution]

Dear zlokesh,

Thank you for your reply!

Below you find 3 screenshots:

1. External Trucking selected

2. Global Shanghai selected

3. No Data point selected

Screenshot 1 and 2 is not what I want.

In screenshot 1 I only want to see full bars of Global Shanghai, Global Dubai and Global Rotterdam in visual 2 when I select  External Trucking in visual 1.

Now I see the External Trucking part of Global Shanghai, Global Dubai and Global Rotterdam highlighted.

For example I added a data table.

When I dont select a data point I see the total value of 384.

When I select External Trucking I want to see 24 highlighted and not 360 shadowed.

I hope you understand what I am trying to do.

Could you otherwise call me at +316 51 36 5308?

Kind regards

Louis

Table

External Trucking selected

Global Shanghai selectedNo Data Point Selected

[louisvp · Accepted solution]

Dear zlokesh,

Thank you for your reply!

Below you find 3 screenshots:

1. External Trucking selected

2. Global Shanghai selected

3. No Data point selected

Screenshot 1 and 2 is not what I want.

In screenshot 1 I only want to see full bars of Global Shanghai, Global Dubai and Global Rotterdam in visual 2 when I select  External Trucking in visual 1.

Now I see the External Trucking part of Global Shanghai, Global Dubai and Global Rotterdam highlighted.

For example I added a data table.

When I dont select a data point I see the total value of 384.

When I select External Trucking I want to see 24 highlighted and not 360 shadowed.

I hope you understand what I am trying to do.

Could you otherwise call me at +316 51 36 5308?

Kind regards

Louis

Table

External Trucking selected

Global Shanghai selectedNo Data Point Selected

[v-juanli-msft · Accepted solution]

Hi @louisvp

Select on the left visual and select Format->Edit interactions, then on the upper right, select "filter" icon.

Best regards

Maggie

[louisvp]

Maggie this is Perfect!

Actually I was looking for this for a very long time. I thought it might not be possible

Beste Regards,

Louis

[zlokesh]

Yes @louisvp, It is possible. For that you have to apply the filter at Visual Level

 (You can see the records in Visual 1 is on filter i.e. only 2, and for Visual 2 all records)

Please go through the below screen shot, you will get the Idea.

If you satisfied,  "Accept the solution" else let me know. Thanks.

 Visual Level Filter