Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I have a date hierarchy with Week Number, Day. I have this on x-axis of a line chart with a measure on Y-axis. By default the line chart sums the measure when I drill up to a week level but I don't want the measure to be summed but rather I want the value of the first monday of each week to be calculated when I drill up at week level.
Does anyone know how to calculate this?
@rishtinz , use isfiltered or is isinscope to check that.
Also use filter like weekday([Date],2) =1, In measure
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Hi Amit, thank you for helping me out on this. The weekday filter you suggested is working out. However, the isinscope seems to be calculating WEEKLY variable and not DAILY when I have expanded down to daily. It only works when I drill down each level at a time.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |