Line chart visualization based on user choice

[Copycat]

Good day beautiful people,

Below you can see my two objects: matrix table and graph. 

What I struggle to achieve: 

If the user does not select any data from the matrix table, let the graph look like in the picture, showing total for each Customer Group for a period of time.

 However, if the user selects Customer Group 1 (or 2, 3, 4) I would like the graph to start showing Data Model data matching the given Customer Group.

So in this example, instead of seeing total for Customer 1, I would like to see 4 lines representing Data Model 1 - 4.

How can I achieve something like this?

[Anonymous · Accepted solution]

Hi  @Copycat ,

Here are the steps you can follow：

1. Create measure.

Group =
SUMX(FILTER(ALL('Table'),'Table'[Customer Group]=MAX('Table'[Customer Group])),[Score])

Group2 =
SUMX(FILTER(ALL('Table'),'Table'[Customer Group]=MAX('Table'[Customer Group])&&'Table'[Model]=MAX('Table'[Model])),[Score])

Flag =
IF(
    HASONEVALUE('Table'[Customer Group]),[Group2],[Group])

2. Fields are placed as follows.

3. Result:

When not selected

After selection.

Best Regards,

Liu Yang

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

[amitchandak]

@Copycat , You can either use customer or group as legend not both in line visual