Forum Discussion
Line graphs show straight line and dates
Hi Josef,
I think I figured out the blank chart issue. I was drawing the slicer names from a table in access but the date type was "number". I changed a few things and the data type is "short text" now and it seems to work.
Thank you for all of your time!
Tammy
Solution SageHey,
it would be very helpful if you would also show your data.
With the screenshot we can actually only guess.
- It may be that your table relations are not present.
- It could be that your data is incorrect.
May I ask you for more details.
If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others
Have a nice day!
BR,
Josef
Graz - Austria
Thank you Josef,
I checked the relationships on of the date table relationships were incorrect. I managed to change it to "both" and it corrected the bottom graph, but it made the lines in the other graphs disappear. Two of the lines from the bottom graph are from the same table as the graphs on top so I'm not sure how come it shows lines for one chart and not the other. I've also attached a screenshot of the data. Thank you for your help!