How to show total on a line graph as secondary across selected line values?

[jovendeluna21]

Hi I am trying to add a total line to a line graph. As the attachment shows, there are selected states each with their own trend line. However, I want to add a line that is the total of of all states or Total U.S. as secondary on which the line will be bit larger/broader than the primary lines. I just want to compare the trend of the National/Total U.S. to selected states.

Is this even possible?

If so, how is it done?

https://drive.google.com/file/d/1HPYREA1Z79jxDkcqnvg_IEpe2RBwwBoZ/view?usp=sharing

[iXpert_info · Accepted solution]

Hey @jovendeluna21 

I'd suggest you to create separate measure for each state and a separate measure for total I know its tedious task but this way you will be able to see the results you want to see. as explained in below link
https://community.powerbi.com/t5/Desktop/Line-chart-with-total-as-a-Legend/td-p/854191

Another suggestion I'd give you is create a Line and stacked column chart where set total value as Line value and States values as column values and location will be as column series.

Did I Answer your question? Please mark this as solution

Best Regards
Jay Patel
iXpert Analytics

[jovendeluna21]

Hello, Jay.

It worked! Thank you very much!