Forum Discussion
Slicer line graph cannot be loaded in Service
I have actually managed to find the solution. For some reason, I had to select "show items with no data" under the month field even thouhg this was not required in desktop.
Here is the graph in desktop. It has date values in months on the x-axis and decimals on the y-axis. Then it has a simple trend line running through.
When I load it into service, I get the above messages. It appears both the x and y axis types have stayed the same. I tried playing around with the axes, and it appears to display something when I use date hierarchy for the month axis. It still behaves weird as it never displays more than two points no matter where you drill. As soon as I change it to just display month on the x-axis though, it just gives the same error.
Also, if I change the x-axis to just an index column from 0-5, it works perfectly and plots every point. It just needs to do this but show months on the x-axis.
I have actually managed to find the solution. For some reason, I had to select "show items with no data" under the month field even thouhg this was not required in desktop.