Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Team,
I am new to power bi.
For 1 year data in that have date column, while creating Week Number with seperate column but getting error in the parameter like below snapshot 1. and getting same week numbers in that column chart as like snapshot 2.
Please check and help me on this!
Thanks in Advance.
snapshot 1
snapshot 2
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
Remove the optional parameter from your WEEKNUM funtion. 1 is the default anyway.
As to why you see TWO on the graph is because weeks can span multiple months. The week that starts July 30 (Sunday) ends in August. You should remvoe the Month level of breakdown in your visual.
Proud to be a Super User! | |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 7 | |
| 4 | |
| 3 |