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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
iponessa
New Member

HELP: problem with What if parameters

Hi everyone!
I'm trying to use a What if parameter for a stacked bar chart but I'm not able to do it.
On Excel this was the result:

iponessa_0-1698939319967.png

It was made with a row for each hour, each hour has 3 values: delivery time, charge time, rest time (transparent color)
All the row where mad to have always 60 (minute) as sum
In Power BI I've made all the dax formula and I have for each hour the 3 number I need: delivery time, charge time, rest time.
My problem is that all this numer came from a DAX formula and not from a table (Query) because they are directly made having some calculation starting from a What if parameter.

I'm able to have a stacked bar chart for 1 hour, but when i try to insert another hour (and I expect to have two different rows (made each one with the three values)) I have each time only one row.
This problem I think is why I cant get a Y axes data table, like all the hours subdivisions.

I already tryed to make a table with all the hours but i cant connect with all the DAX formula, as saying: all this three DAX formula are relatet to hour 8pm, all these three are for 9pm, .....
In this case I shoul be able to have how many rows as all the hours (each one stacked with the three numvbers).

 

iponessa_1-1698939819981.pngiponessa_2-1698939836775.png

 

 


Please really need help cause I'm getting really crazy!
Thank you so much

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.