What if parameter not working when used in power bi report server

[zainqazi96]

I have created an report in which i have used what if parameters using field and i have passed it on slicer and visual as well , now its working perfectly on power bi service and desktop but it is not working on On prem report server , what could be the issue and what would be the way around

[Anonymous]

Hi @zainqazi96 ,

As of now, What-If Parameters are not fully supported in Power BI Report Server. While they work seamlessly in Power BI Desktop and the Power BI Service, their availability in the on-premises Report Server environment is limited.

You can consider alternative approaches:

          Use Measures: Instead of calculated columns, create measures that reference the What-If Parameters. Measures are evaluated dynamically based on the report context, allowing you to achieve similar functionality.

Below is the post will help you:

Solved: New Field Parameters feature and May 2022 PBI Repo... - Microsoft Fabric Community

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zainqazi96]

How can measures perform same functionaliy?? could you please elaborate 

[Anonymous]

Hi @zainqazi96 ,

Below is my table:

The final output is shown in the following figure:

Below is the official link will help you:

Use parameters to visualize variables - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

The documentation does not mention any RS limitations

Use parameters to visualize variables - Power BI | Microsoft Learn

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[zainqazi96]

Actually what if parameters for field is not released yet for RS and that's why it wont work