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,
Does anyone know how to connect the line graph dots like in the Picture 2?
I cant find a way how connect the line if the previous/next month have nil data.
For example in Picture 1: 2016 Sep=1; Oct= nil data; Nov=3, the line only connect if there is a data on each month.
Picture1 (Power Bi): Picture 2 (Power Pivot):
Solved! Go to Solution.
Go to Edit Query, check if column for generating the line graph contains null value. If it is, replace the null value with 0. Then you should get the chart as you want.
Below is an example for your reference.
Go to Edit Query, check if column for generating the line graph contains null value. If it is, replace the null value with 0. Then you should get the chart as you want.
Below is an example for your reference.
Thank you so much Jessica Seiya!
Really appreciate it.
Now I know where is wrong.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |