Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
What am I missing here? There are 41 'SAValidation' dates total in May 2018, 15 of these are distinct dates. but the graphs show 23?
It's incorrect on all months of course but this was the best example
hi, @Anonymous
I have test on your pbix file, Reason is that "SAValidation" is a datetime column with different time, but date column only with "12:00:00", so you could not create the relationship by these two columns.
You should create a new "SAValidation" column
new SAValidation = DATE(YEAR(Query1[SavalidationDate]),MONTH(Query1[SavalidationDate]),DAY(Query1[SavalidationDate]))
Then use new "SAValidation" column create a relationship with date table
Best Regards,
Lin
What is the SAValidation data type ? It looks like text. I think the fault comes from there
What is the value on x axis. Given informations are deficient
Please share your data set or pbix.
X-Axis uses a date table.
Column: Date/Time
Format 2001-01-01 (yyyy-MM-dd)
I'm asking for data type of SAValidation.
It's to hard to help without having your dataset and chart. I couldn't guess what did you do in your example.
Please check SAValidation data type and be sure if it is date and check your tables relations. Maybe if you change Cross filter direction to both it would be work
SaValidation is Date/time as data type just as the image I posted. I understand it's harder without my actual dataset but I can't share it atm.
I will try the cross filter direction but it still seems wierd that the graphs show a value that is not present in the dataset no matter how I twist the data 🙂
Relations is basically just one many to one relation to the Date table så nothing fancy there either. Just the Count function in the graphs that don't count like I want them to.
hi, @Anonymous
I have tested on my side, it works well.
So could you please share your sample pbix file(just keep the date column that could reduce the issue, remove other fields),
there should be something wrong in your other process.
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |