Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |