filter data to input in a line chart from 2 tables depending on a slicer selection

[X19203659]

Hello Community,

As you can see below I have a slicer and 2 line charts (data coming from 2 different tables).

what I would like to succeed to do is to only see

- the linechart 1 when there is no selection (or all selected)

- the linechart 2 when one of the positions is selected in the slicer

(if possible I dont want to use the bookmark navigator)

Would it be possible to filter and select the data to show in the line chart? (there are 2 different tables) 

Many thank in adavnce for your help.

Kind regards

Guillaume

[v-jianboli-msft · Accepted solution]

Hi @X19203659 ,

Please try to use the sync slicer:

First, select one of the slicer you want to synchronized:

In the Sync slicers pane, expand Advanced options, and enter a name for the group. You can name it anything you want:

Then select another slicer you want to sync with the first, and enter the same name in the group name box. Be sure to enter it exactly the same.

Final output:

For more details, please refer to:

Slicers in Power BI

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[X19203659]

Hi Jianbo,

Many thanks for your great explanation  and quck explanation!

it works perfectly

Kind regards

Guillaume

[v-jianboli-msft]

Hi @X19203659 ,

Based on your description, I have create a simple sample like this:

First create a table for slicer:

Then create a measure for the line chart:

Measure = SWITCH(SELECTEDVALUE('for slicer'[Value]),

"A",CALCULATE(MAX('Table (2)'[Value]),FILTER('Table (2)',[Category]="A")),

"B",CALCULATE(MAX('Table (2)'[Value]),FILTER('Table (2)',[Category]="B")),

"C",CALCULATE(MAX('Table (2)'[Value]),FILTER('Table (2)',[Category]="C")),

MAX('Table'[value]))

Apply it to the line chart:

Final output:

If this is not what you want, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[X19203659]

Hi Jianbo,

Thank you very much for this great help! 🙂

Unfortunatly, I have one last issue on the same topics related.

On the same sheet, I have 2 slicer filtering the same data :

- 1 slicer filtering a board

- 1 slicer filtering the Graph

These 2 slicers are not synchronised. They always should have the same value to get the correct output . 

I am wondering if there is a solution synchronised them together.

The board slicer is already synchonised with other slicer existing in other sheets.

I ameneded your PowerBI file to give you an example but i dont see any way to share it with you.

How can i share this power bi file with you? (below you have 2 screenshot explaining the situation)

(here below is a bad example)

(here below is a correct example)

Many thanks in advance for your help!

Kind regrads,

Guillaume