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.
I'm sorry for asking such a basic question.
I'm ABSOLUTELY new to this program, I was just sucked doing into it yesterday. I kind of understand it's like an easier version of Excel but now I want to know one thing.
In my datasets, I'm trying to filter data by the day. The issue is that, the data is recorded by time, right down to the absolute second. So when I filter it, it's filtering it by seconds. When it does that, it's basically telling me, there's 1 item for every second.
I want to ignore the Seconds and Hours part and just focus on the date. Is that possible? Tomorrow I will start watching the full courses & webinars but can someone please help me on this one for today T_T
Solved! Go to Solution.
Hi @Tradingpost
You may try to add column in Query Editor as below:
By the way, as Ashish_Mathur said. You also need to set the column data type to get the date column.
Regards,
Cherie
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |