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.
I have a line chart that won't display how I want. See attached .pbix file as example. I have one table that is shipments data. Another table that is a goal table. The two tables are lnked by a date table. I want to plot the shipments by day and the goal by day. The shipments line correct is correct as it show the number of units shipped each day. The goal line is just flat as it's showing the average of all the days but it should show the goal (which changes) for each day. The below picture shows what I want (the flat dark blue line at the top should be like the red line that is drawn)
Here is the .pbix file: pibix file
Solved! Go to Solution.
Just swap out the date that is on the x-axis for the date from the date table.
@Anonymous , Date has to come from the date table. Please find the attached file after Signature.
@Anonymous , Date has to come from the date table. Please find the attached file after Signature.
Just swap out the date that is on the x-axis for the date from the date table.
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |