Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am trying to create a slicer that slicers by hours/minutes. I have data column in dd/mm/yyyy hh:mm:ss format. Does anyone have any idea how I could do this?.
Thanks,
Solved! Go to Solution.
Best practice is to split your DateTime columns into Date and Time columns, and then add Date and Time tables to your model. Please see this article and embedded videos.
Calculate and Format Durations in DAX – Hoosier BI
Time Tables in Power BI – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Best practice is to split your DateTime columns into Date and Time columns, and then add Date and Time tables to your model. Please see this article and embedded videos.
Calculate and Format Durations in DAX – Hoosier BI
Time Tables in Power BI – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for the advice. I'll try follow the articles.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
93 | |
87 | |
35 | |
35 |
User | Count |
---|---|
154 | |
102 | |
82 | |
64 | |
54 |