Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
Hello, Jay.
It worked! Thank you very much!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |