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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 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.