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,
I am quite new to Power BI world and I am facing some difficulties with my report.
I am using data from SAP with a DirectQuery from SAP.
I'm trying to add a date slicer but the data I have is not allowing me to do so.
At the left are my two columns separately (Calendar day & Calendar year / week). From what I understood, it uses a unique code, so when I put them together it gives me the date in a good format (table in the middle).
Unfortunately when I want to make a slicer, it is not showing in the correct format (slicer at the right).
Any recommendations on how I can make this work?
Thanks you for the help.
regards
YM
Hi @YounesM,
I'd try to create a new column in PowerQuery or in DAX which contains the expected date.
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.