Hello
I have this table:
Product, Attribute, Date, Value
I want to display in a line graph, the Product as Legend and the Value per Attribute as separate lines.
So I put the following columns in the graph's fields:
Date in Axis
Product in Legend
Max of Value in Values
And then I create a slicer where I put:
Attribute in the Field
However, when I choose more than one Attributes, it displays the max of both of them in one line, instead of the max of each of them in separate lines.
How can I fix this?
Thanks!
I have this table:
Product, Attribute, Date, Value
I want to display in a line graph, the Product as Legend and the Value per Attribute as separate lines.
So I put the following columns in the graph's fields:
Date in Axis
Product in Legend
Max of Value in Values
And then I create a slicer where I put:
Attribute in the Field
However, when I choose more than one Attributes, it displays the max of both of them in one line, instead of the max of each of them in separate lines.
How can I fix this?
Thanks!