Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
foging
Frequent Visitor

What-if parameter to offset individual projects

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?

 

7190D212-AC9A-4307-8ABA-E0EBC8F9E2F5.GIF

3 REPLIES 3
foging
Frequent Visitor

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

amitchandak
Super User
Super User

@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

)

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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?

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors