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.
As shown in picture above. I plotted a line graph and turn it into dots since I dont want the dots to be connected.
My problem now is that when I drill down the data, not every day is shown on the x-axis (which is what I want). It will be still ok if the shown dots are correctly spaced. For example, the data of August 19, 22, 24, 25,26 are equally spaced, which created a false impression that the dots of data are collected at an equal interval of date, which are not.
Thank you in advance.
Solved! Go to Solution.
Hi!
You can create a measure like this
calculate(values'datestabel'[date],
if(isblank(sum('yourtable'[columnwithvalues])),
blank() , --(or 0 depending on what you want to see)
sum('table'[column])
)
)
to show blank (zero) values.
Regards,
Arthur
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |