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: 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). Please really need help cause I'm getting really crazy! Thank you so much
What-if parameters
At the retail company i work, the sales men are giving the customers discounts. At the end of the year, the sum of sales after discount =100M and the total dicounts amount=45M. i want to make a what if parameter to the discounts in which i make it dynamic to show that : if we decreased the discount amount by 10% the sales would have increased by so and so .. how can I achieve that ?What If analysis option is greyed out in Power BI Desktop
Is there conditions to when the What If parameter is enabled vs disabled in Power BI? I've attempted to use this using DirectQuery, SSAS Live connection and Import. There does not seem be a dependency on the data source. The box is at first active prior to adding a data source. Once I have connected to any source of data. The What If parameter becomes greyed out in Power BI Desktop (Oct 2017) optimized for Report Server. After that, I cannot seem to get it to become active again. I've been following blogs on how to create What If parameters. I cannot figure out why this option is greyed out. Thanks for your help!
Creating groups based on scenario value outcomes
Hi there, I hope you can help!! As an output, I need a table which counts the number of hours of an activity, against the size of the activity (grouped) e.g. 0-9 30.00 10-19 2.00 As a benchmark for scenario planning I have done this by creating bins, and am using a measure to sum up as appropriate. However, I need to create scenarios. There are two scenarios within the same output: (1) Scenario value increases or decreases the number of total hours but the size remains the same - this I have managed using the same bins as in the benchmark. The actual duration calc is based on a total number of attendees/size of the group = no. of events to run * duration. This is the scenario where we expect multiple of the same event to run. (2) Where there is only one event running, the scenario value applies to the number of attendees instead - the duration will not fluctuate I need to then combine these outputs into the one table as above, so we can see the change in hours (resultant from scen1), and the change in distribution across the size bands (resultant from scen2(. We don't need a distinction between scen 1 and 2 in the final table. The problem is that the outputs from scenario (2) are still based on the original event size and not on the scenario size output, and I don't know how to group them so it recognises the new value rather than the original. Hope that makes sense - appreciate any helps as this is driving me mad!
