The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Some of my line graph is flat because it has missing dates or the dates contain the same temperature data as previous dates. how do i remove them?
two solutions.
1) The way I've dealt with situations like this is to create a measure that defaults to blank if the sum is zero. (This is assuming you KNOW the data should never actually be zero... which, for a temperature readout seems feasible).
MEASURE =
var line_value = COALESCE(SUM([value]), 0)
return
IF(line_value = 0 , BLANK(), line_value)
2) If you are okay with the x axis skipping values, change it from "Continuous" to "categorical"
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
97 | |
55 | |
49 | |
46 |