Show attributes as separate lines in a graph

[Anonymous]

Hello

I have this table:

Col1, Col2, Col3, Col4

Prod1, Attr1, 69, 01/01/21

Prod2, Attr1, 59, 01/02/21

I created a line graph where I put:

Axis = Col4

Legend = Col1

Values = Max of Col3

I also created a slicer where I put:

Field = Col2

Now, when I select a specific Prod and more than one Attr, it shows the line as max of both, instead of each separately.

How can I make it show it separately?

Thanks!

[Gabriel_Walkman]

If I understood correctly, you want to see Col2 values (ie. Attr1, Attr2) separately? But you don't have any grouping for Col2.

Maybe you need to create another visual next to this one, where you switch Col2 to X-axis?

Another option, if the Col2 values are few and well defined, would be to create a measure per attribute and use those as values. Ie.

Attr1Max = calculate( max([Col3]), filter( 'Table', [Col2] = "Attr1" )) 

[Anonymous]

@Gabriel_Walkman  thanks but Measures cannot be used in slicers so this dismisses them

[Gabriel_Walkman]

I offered you two options. How about the first one?

The latter one does not require using measures as filters but it might not make sense otherwise. 

New idea, how about create a Col5 = Col1 & " " & Col2 and use that as legend?

[Anonymous]

@Gabriel_Walkman  thanks! 

1) I think the concat is not preferable due to creating a very large number of inconvenient to filter/select entries.

2) Can you explain please the use of Groups? I have not used them before

3) The below seems interesting:

Attr1Max = calculate( max([Col3]), filter( 'Table', [Col2] = "Attr1" )) 

However, it needs to be something like:

Attr1Max = calculate( max([Col3]), filter( 'Table', [Col2] = [Col2] )) 

So that it will work for any Attr, can that work?

Thanks!

[Anonymous]

Attr1Max = calculate( max([Col3]), filter( 'Table', [Col2] = "Attr1" )) 

However, it needs to be something like:

Attr1Max = calculate( max([Col3]), filter( 'Table', [Col2] = [Col2] )) 

So that it will work for any Attr, can that work?

Thanks!

[Anonymous]

Attr1Max = calculate( max([Col3]), filter( 'Table', [Col2] = [Col2] )) 

So that it will work for any Attr, can that work?

Thanks!

[Gabriel_Walkman]

1) You can still create slicers from Col1 and Col2 as normally, even if you'd use the concatenated value in the visual.

2) By grouping I mean ie. something in either x-axis or legend. "group by month", "group by ColX" etc.

3) No, it would not work like that at all. I'd forget that suggestion altogether, I was very tired when I wrote that.

[vanessafvg]

can you just screenshot your visual with the visual pane setttings? so much easier to understand that way and see what is going on.