Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Ayyappa5678
Helper III
Helper III

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

Ayyappa5678_0-1691745322914.png

snapshot 2

Ayyappa5678_1-1691746787687.png

 

 

2 REPLIES 2
foodd
Super User
Super User

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.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors