Hi - PBI noob here so looking for some help.
I have built a scatter plot with percentage of time lost per category over time. Some value are outrageously large and present as something like 5300% of time lost. Obviously, this is usless, so in my SQL query, i have forced any value over 100% to be set at 100%.
In my table visual, i can see all value as expected. Where a value used to be 5300%, it now shows as 100%...great!
Table looks a bit like this (this is cut down):
Index | List Length | Total Time Lost | % Time Lost
1 | 210 | 111779 | 100
2 | 690 | 649 | 94
and so on......
However, when I plot these value on a scatter, my highest value is 84%. Interaction is set because when i click on any of the values, including number 1 above, the scatter plot changes and i can see the value sitting at 100%.
Before forcing values > 100% to 100% in my query, all values were present on my scatter and the data was skewed.
The key question for me here is, why is the data correct in the table visual, but not the scatter when using the same fields and measures.
Anyone have any ideas as to why when all data is selected, i dont see any values above 84%.
As mentioned, i am a noob at this so please be gentle! 🙂
Thanks in advance!
