The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
85 | |
84 | |
36 | |
34 | |
32 |
User | Count |
---|---|
93 | |
79 | |
66 | |
55 | |
52 |