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.
Hello! I'm using Line and Clustered Column Chart, and am struggling to display blue bars from Jan to Dec (ie. all bars) but only show red line until April (ie. Jan to Apr) and nothing beyond April. Is there a way to do such conditional filter? Thanks!
Without knowing the details of DAX and sample data, data model, it is tough to answer.
One best guess is add a new measure to cut off at April or modify the existing measure:
Just giving an idea of the measure to filter up to previous month:
Calculate (Sum('Table'[Amount]), FILTER('Table',MONTH('Table'[date]) < MONTH(now())))
If need to hard code, then replace MONTH(now()) as 4.
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 |
---|---|
80 | |
40 | |
31 | |
27 | |
27 |