One line that has the values of other lines

[vanducthien2]

My boss wanted me to create a line chart denoting 4 legends (4 products) and each legend (product) has 4 values: 2021Sales, 2020Sales, %Growth and Sales Growth (my x-axis is Month, by the way). However, his request seemed out of reach for me. He said that he wanted a line chart that indicated the 2021Sales of the 4 products, which was equivalent to 4 lines and their data labels appearing on the chart and alongside with that were the remaining 3 values (which also had to APPEAR beneath that 2021Sales data label). He didn't want me to use tooltips because he found hovering the mouse on to each legend to appear the tooltip table ridiculous and because he wanted to see the "picture" as a whole, not in a table format but in a line chart format. I found this nearly impossible and would make the chart seem over-crowded with data. What should I do? Thanks in advance!

[v-yanjiang-msft]

Hi @vanducthien2 ，

I’m not very clear about your expected output, can you please provide a sample and explain it more?

Best Regards,
Community Support Team _ kalyj

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

[amitchandak]

@vanducthien2 , If you want these 4 as axis value - 2021Sales, 2020Sales, %Growth and Sales Growth , create a new table using summarize and union with product any other dimension you want to filter as current filter will not work on new table

Union(
Summarize(Table, Table[Product], "Name", "2021Sales", [2021Sales]),
Summarize(Table, Table[Product], "Name", "2020Sales", [2020Sales]),
Summarize(Table, Table[Product], "Name", "%Growth", [%Growth]),
Summarize(Table, Table[Product], "Name", "Sales Growth", [Sales Growth])
)

Join this table back with dimensions if needed

[vanducthien2]

Oh, I forgot to mention that all 4 values up there were calculated measures, neither columns nor calculated columns.