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.
Hi All,
I have imported the PowerBi table that was links to an excel file into a sharepoint list to create a better user experience.
However my charts are not out by one month...
I get this in the new Sharepoint List- All the data needs to be moved to the right by one month.
Than you in advance for your help!
cheers,
Peter
Sorry- I ment to say all my charts are out by one month.
e.g., Feb is showing are Jan, March is showing as Feb etc...
Regards,
Peter
@Anonymous , Problem with Calendar. Create correct calendar
@Anonymous , Not very clear, Can you share sample data and sample output.
Your date that is joining with date table may have timestamp. In that case remove timestamp
New DATE =[timestamp].date
or
New DATE =date(year([timestamp]),month([timestamp]),day([timestamp]))
@Anonymous not sue I fully followed your question, did you check the data and check if date value is correct? What measures are you using? Maybe there is something in the calculation, without seeing the sample data and also the measure (if used), it is hard to say what is going on.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |