Line charts to automatically show all variables after slicer selection

[alexzhao]

Hi Everyone,

Currently I have a dataset as below:

Date	Segment	Variable	Value
D1	A	v1	0.5
D2	A	v1	0.4
D3	A	v1	0.6
D1	A	v2	0.2
D2	A	v2	0.3
D3	A	v2	0.5
D1	A	v3	0.6
D2	A	v3	0.5
D3	A	v3	0.6
D1	B	v4	0.5
D2	B	v4	0.4
D3	B	v4	0.6
D1	B	v5	0.2
D2	B	v5	0.3
D3	B	v5	0.5
D1	B	v6	0.6
D2	B	v6	0.5
D3	B	v6	0.6

I created a slicer that filters the Segment (A or B). Each Segment will have 3 variables.

Here is my question:

Is it possible to build 3 line charts (Date is x-asix, Value is y-axis), each chart shows 1 of the variables for the selected Segment, order does not matter?

If I select Segment A in the slicer, the 3 line charts will show V1, V2 , V3.

If I select Segment B in the slicer, the 3 line charts will change to V4, V5, V6.

Hence, the only thing I need to change is the slicer for Segment. I do not want to manually select which variable to show in the line chart.

Thank you!

Alex

[MFelix]

Hi @alexzhao ,

Not sure if I understand your question properly, but you can add to any visual a filter and then change the options has you need without being dependent on a slicer, this will force that visual to always be based on the varuable in this case:

This is not your example but just highlithing the filter pane for your reference.

[alexzhao]

Hi @MFelix ,

Thanks for the response! I edited my post to be more clear on my objective.

The goal is to let 3 line charts get automatically updated to show the variables for the selected segment. Since different segment contains different variables, after I select another segment in the slicer, I want the charts to automatically update and reflect the corresponding variables for the selected segment. Thanks.

[MFelix · Accepted solution]

Hi @alexzhao ,

If you add the variable has legend on your chart that selection will be done directly based on the options you are selecting, even if you do not use the legend the data that is presented is only concerning the data for that segment since the slicer filters out only those rows and respective values.