Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |