Dinamic line chart

[vbourbeau]

Hi,

I have a line chart with 7 lines value on it. I want to add a segment filter or something else that allow my user to select the line to be visible on the line chart. Exemple he want line 2 and 3 only well the chart only show this lines...

Thank you.

[Jorgast]

Create a slicer and use the whatever column you are using for your "Legend" as your filter

[vbourbeau]

No it's not a measure.

I don't have any legend in a slicer?

[Vvelarde · Accepted solution]

@vbourbeau 

Ok, try with this:

Step 1: Create a disconnected table with Temperature types.

Step 2: Insert in a slicer this column

Step 3: Create a measure:

ShowLine =
SWITCH (
    SELECTEDVALUE ( Slicer[Column1] ),
    "A", SUM ( Table4[Column A] ),
    "B", SUM ( Table4[Column B] ),
    "C", SUM ( Table4[Column C] )
)

Step 4: Drag into values section of your chart. (Remove the others columns)

Step 5: Drag the Column from disconnected table to Legend.

Ready

[vbourbeau]

Wow thank you I'll remind this kind of twist 🙂

[Vvelarde]

@vbourbeau 

Hi, your line are measures?

Regards

Victor