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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello all experts!
I've created some parameters to manipulate a resource planning visual, but the parameters are pretty clunky and affect "everything". I would like to be, expecially for the "project delay" parameter, be able to chose a project and offset only that project.
Is that possible? I've no good idea where to start, so I'm hoping someone could help me?
I've tested the Switch function, but I don't understand where to put it and how to use it for individual delay of a specific project. I would attach a pbix if I could, but can't find where to do it.
Edit: Use this link for the pbix: https://drive.google.com/file/d/1bt5DvZdGEdzS02ZUtNTl6eLBxjJ3fSH6/view?usp=sharing
@foging , You have to create that many offset and then you can have measure like
Switch(Max(Table[Project])
"Project 1", [Offset 1 Measure],
"Project 2", [Offset 1 Measure],
// add others
1 //default value
)
Ok, I think I got it now, thanks @amitchandak !
One question remains. This has to be hardcoded, right? No way to let new projects come in automatically? No way to create a drop down to select project and offset it individually?
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.