topic Re: What-if parameter : Visuals are not changing according to the parameter changes (using slicer) in DAX Commands and Tips

What-if parameter : Visuals are not changing according to the parameter changes (using slicer)

Anonymous — Thu, 16 Jun 2022 11:04:39 GMT

I added a What-if parameter to my Power BI report and it generated a table and a measure. Using that measure I did a calculation as given below:

Backup gen qty with powercut hrs = MainTable[Fuel per Hour] * 'power cut hours'[power cut hours Value]

In here 'power cut hours'[power cut hours Value] is the measure created when adding What-if parameter.

But the selected value from the slicer does not change the output in my above calculation, it just only give a blank and as a result visuals are not changing either.

Please kindly give a solutionn for this.

Re: What-if parameter : Visuals are not changing according to the parameter changes (using slicer)

Anonymous — Mon, 20 Jun 2022 06:09:02 GMT

Hi Anonymous

Can you provide your sample ? Through your text description, I have no way to successfully restore your scene. So I hope you can provide your sample or pbix file(remove sensitive info) so that we can better deal with the problem.

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: What-if parameter : Visuals are not changing according to the parameter changes (using slicer)

Anonymous — Mon, 20 Jun 2022 12:14:13 GMT

Thanks for your response!!!

As I said following screen shot will show you the equation I have created by using the measure which was created while adding the what if parameter. As you can see it will only show blank when i change the parameter from the slicer.

So in the report when i change the parameter visuals aren't changing as a result of the blank.