cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
X19203659
Frequent Visitor

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

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) 

 

X19203659_1-1658841810351.png

 

Many thank in adavnce for your help.

 

Kind regards

 

Guillaume

 

 

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @X19203659 ,

 

Please try to use the sync slicer:

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

vjianbolimsft_0-1659343272196.png

 

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

vjianbolimsft_1-1659343272198.png

 

 

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:

 

vjianbolimsft_2-1659343272201.png

 

vjianbolimsft_3-1659343272204.png

 

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.

View solution in original post

4 REPLIES 4
v-jianboli-msft
Community Support
Community Support

Hi @X19203659 ,

 

Please try to use the sync slicer:

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

vjianbolimsft_0-1659343272196.png

 

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

vjianbolimsft_1-1659343272198.png

 

 

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:

 

vjianbolimsft_2-1659343272201.png

 

vjianbolimsft_3-1659343272204.png

 

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.

Hi Jianbo,

 

Many thanks for your great explanation  and quck explanation!

 

it works perfectly

 

Kind regards

 

Guillaume

v-jianboli-msft
Community Support
Community Support

Hi @X19203659 ,

 

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

vjianbolimsft_0-1659091343473.png

 

vjianbolimsft_1-1659091343475.png

 

vjianbolimsft_2-1659091343476.png

 

First create a table for slicer:

vjianbolimsft_3-1659091343477.png

 

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:

vjianbolimsft_4-1659091343479.png

 

Final output:

vjianbolimsft_5-1659091343482.png

 

vjianbolimsft_6-1659091343483.png

 

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.

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)

X19203659_0-1659297999428.png

 

(here below is a correct example)

X19203659_1-1659298152065.png

 

Many thanks in advance for your help!

 

Kind regrads,

 

Guillaume 

 

 

 

   

Helpful resources

Announcements
Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.