Forum Discussion
Week Number of Parameter getting error, Kindly help me!
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
2 Replies
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-Forum/ba-p/963216
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.
