Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi All,
How can I convert week no into date ?
So that I can use that in continuous X-Axis of my visual.
Thanks,
Arul
Solved! Go to Solution.
@Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
@Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
It helps. Thank you
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 53 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 116 | |
| 105 | |
| 41 | |
| 34 | |
| 25 |