Forum Discussion
(URGENT) Line chart - Values skipped
Hello everyone I have an urgent problem that I can't solve!
The problem is that for a curve graph I have several values in X axis (from 0 to 7000) and in Y I have values that fluctuate between 0, 0.2 and 0.4 mainly.
When I display my graph in full, without filters on the frequencies there are frequencies that jump but when I apply a filter, reduce the frequencies, the values that jumped appear.
Example :
- With filter : Frequency <= 80 (The Frequency 6.5 which has the value 0.02 appears)
- Without filter : The Frequency 6.5 doesn't appear anymore
It skipped the frequency 6.5 which is between 5.7 and 7.3 and which has the value 0.02 in the Y axis.
I thank you in advance for your help !
3 Replies
- HotChilli
Community Champion
I see that the 'i' warning is activated on the unfiltered chart. I suspect that an algorithm has kicked in to limit the plotted values because there are too many values.
Can you confirm by reading the message on the 'i' at the top right of the chart?
- HotChilli
It's a complex subject.
I believe they changed the algorithm relatively recently (not sure when) so you might experiment with the high density sampling toggle in Settings
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-high-density-sampling
