Forum Discussion

ashahbaz's avatar
ashahbaz
New Member
4 years ago
Solved

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

 

  • Hi ashahbaz ,

    Current power bi does not support creating dynamic calculate column/table based on filter/slicer. 

     

    Depending on your needs, you want to get different language displays according to different parameters, see the following article for the steps, which are very detailed.

    Multi-Language Reports using Power BI Parameters

     

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

1 Reply

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support

    Hi ashahbaz ,

    Current power bi does not support creating dynamic calculate column/table based on filter/slicer. 

     

    Depending on your needs, you want to get different language displays according to different parameters, see the following article for the steps, which are very detailed.

    Multi-Language Reports using Power BI Parameters

     

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien