What if parameter not working when used in power bi report server
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
What If Paramter Value Update in Power BI Report Server
Hi, I have one requirment to change the column names and values in report as per user selected language. English and Arabic are two languages in the slicer. I have Date dimension containing Year column values in Arabic and English (Year En , Year Ar). If user selects English, report will show data from Year En else it will be from Arabic. I'm using "What IF" paramter (name is PM) to control this behaviour. This paramter has one Measure Value (PM Value) used to control the display. This Measure has below formula PM Value = SELECTEDVALUE('PM'[PM],0) Based on this measure, one Culture measure is defined with below formula Culture = SWITCH(PM[PM Value],0,"En",1,"Ar") Formula for displayed column of year is as below YR = SWITCH([Culture],"En",'Date'[Year_En],"Ar",'Date'[Year_Ar]) PM is shown as slicer to the end user. Expectation is user selected value will be passed to PM Value and report will chnage the display to show either Arabic or English content. But this is not working as shown below, User has selected value as 1 (Arabic) but value is still shown in English due to alternate value of 0 in SelectedValue function. If i chnage alternate value in PM Value function, display will chnage but its not accepting value from slicer, Can you please help. Model Data data
