Line chart with total as a Legend

Hi Anonymous ,

There is a limitation for this scenario. After draging column into the "Legend" field, we can only add one value into "Value" field. For your request, we can't add another column or measure about total values when we have put the "Product" column into "Legend" Field. There are two workarounds that you could try.

• If there are not many products in your table, you could create measures per products to show them.

a = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Product] = "a"))
b = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Product] = "b"))
Total = CALCULATE(SUM('Table'[Amount]),ALL('Table'[Product]))

• If there are many products, please try to use a slicer to filter per products

Measure = CALCULATE(SUM('Table'[Amount]),ALLSELECTED('Table'[Product]))
Total = CALCULATE(SUM('Table'[Amount]),ALL('Table'[Product]))

Best Regards,

Xue Ding

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

Hi Anonymous ,

Do you try the ways? Do they make sense? If the answer is helpful, please accept it as a solution. If you solved by yourself, welcome to share the solution. More people who have the same request will benefit here.

Best Regards,

Xue Ding

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