Forum Discussion
Visual showing nothing when no changes to underlying data were made
Community Championare you able to share your solution? something must have changed but its hard to know without seeing your solution, can you share it? are you sure you dont have a filter on it somewhere?
No unfortunately I cant share as theres private information on the tables, the only filter on the page is based on a date table and exculde data that has a blank value for year. when i include blank in the filter they show up but no relationships have changed so this makes no sense. It was working last week and I havent touched since then and the data its pulling from hasnt changed either
Ok so for some reason the date/time column had switched to text somehow so i swapped that back to date and time but now its sorting them by american date so for example 2 instances that were created on the 12/04/2023 are showing up in december of this year instead of april and there is still some showing up as blank instead of going into the correct column. This is all coming from the same table so why is it only happening to some but not everything on the table
- vanessafvg
it would really depend on where the data is coming from i guesss, what source are you using to pull this data?
There could be a myriad of reasons to be honest but its hard to know without being able to look.
This does happen with data, the easiest solution very often is just to from the text data, create a new date column using a transformation to force the date format you want, so if you are able to share the date values as I am sure those aren't private I can show you how to force the format you want in power query, this is sometimes easier than trying to control a unpredictable source, however if you can figure out why it is happening, or if you provide the data with only the dates in it that would be useful.