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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All,
Currently facing issue with slicer having calculated measures as mentioned below. I'm trying to filter table below based on slicer selction and slicer is not working please suggest.
Current month = MAX(‘Table’[current_period_ind])-1
Previous month = MAX(‘Table’ [current_period_ind])-2
Parameter = {
("Current month", NAMEOF('MEASURES_TABLE'[Current month]), 0),
("Previous month", NAMEOF('MEASURES_TABLE'[Previous month]), 1)
}
Matrix table/Dataset sample:
Hi @Snagalapur ,
Have you added parameter column to the table as it's not showing in the screenshot? if not You should add it to the table in order to filter data with parameter slicer.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!