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.
Hello community,
This is my first time posting, so sorry if i don´t find the right place to add the post.
This is, I am sure, a very simple question but i am totally blocked. I have an excel table with 4 simple columns, one of them a date column that embrace dates between 2016 and 2020.
When i add a slicer, it does not recognice al the row date totally, and give me back a big amount of blanck date lines.
Hope the link is working
I don´t know what to do.
Any help will be welcome.
Cheers
Solved! Go to Solution.
Your date column is actually in datetime format, so it won't make a good relationship with your Date table. In the query editor, change that column to just Date format.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Your date column is actually in datetime format, so it won't make a good relationship with your Date table. In the query editor, change that column to just Date format.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Superthanks
Sorry but i don´t know how to attach the pbix, anyway you can see it in this new onedrive link.
https://1drv.ms/u/s!AsWx8pso9cwO4UDIYiKzClnZ8ebE?e=s807Xr
Thanks a lot
@SMOYAMI , We are not able access the app.
There can few reason. Is date in slicer and in table are same or rate from different table,
If from different are they joined
If from same table are they interacting
If interacting are you using all, allselected or allexcept in you measure ?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |