Showing individual graphic lines, for each data selected on filter

[Rabelo]

Hi guys!

Looking for an answer ... a challenge: is it possible to create a Line Graphic that shows a diferent line with the values of a MEASURE, for each diferent data selected on external filter ?

For example: a table with 20 sellers and 2 of them selected on external filter: the graphic would create 2 individual lines, showing the sells of each seller selected ... or 3 lines if 3 sellers selected .... and so on.

Is that possible ?

Best Regards!!

[Rabelo]

Fantastic !!!

Simple & Genial 😄

Tks so much dear Nono Chen 👍

[parry2k]

@Anonymous I don't understand why you would reply to the post while I'm waiting on the OP, and how your solution is different than what I suggested. Please refrain from answering until OP answers the question. 

[Rabelo]

Thks so much for your fast answer and tip !

[Anonymous · Accepted solution]

Hi @Rabelo 

Thank you very much parry2k for your prompt reply.

Maybe this is what you need:

“Table”

"Slicer Seller"

Slicer Seller = 
SELECTCOLUMNS('Table', "Seller", 'Table'[Seller])

Create a measure.

Measure = 
IF(
    ISFILTERED('Slicer Seller'[Seller]),
    CALCULATE(
        SUM('Table'[Sales Amount]),
        FILTER(
            'Table',
            'Table'[Seller] IN VALUES('Slicer Seller'[Seller])
        )
    ),
    BLANK()
)

Here is the result.

Regards,

Nono Chen

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

[parry2k]

@Rabelo If I understood it correctly, you can easily achieve this by putting the seller on the legend.