Forum Discussion

Andy_W's avatar
Andy_W
New Member
10 years ago
Solved

Newbie trying to convert SSRS report functionality to Power BI

Hi, I just got my hands on Power BI and now trying get some functionality from SSRS to Power BI... And I'm a newbie in both :smileyvery-happy:    Is this, or even part of it, possible with Dax or ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi Andy_W,

     

    In Power BI, we can create a calculated column, then specify DAX expression with Switch() function to return corresponding value based on the condition like below:

     

    Column = SWITCH(TRUE(),Table1[value]>60,"Green",Table1[value]<=60, "Red")

     

     

    SWITCH Function (DAX)

    DAX – Making the “Case” for SWITCH()

     

    In addition, in Power BI, Query Parameter is available, but we are not able to use reference the query parameter in DAX expression like in SSRS. Regarding query parameter, please see this article: Deep Dive into Query Parameters and Power BI Templates.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi Andy_W,

 

In Power BI, we can create a calculated column, then specify DAX expression with Switch() function to return corresponding value based on the condition like below:

 

Column = SWITCH(TRUE(),Table1[value]>60,"Green",Table1[value]<=60, "Red")

 

 

SWITCH Function (DAX)

DAX – Making the “Case” for SWITCH()

 

In addition, in Power BI, Query Parameter is available, but we are not able to use reference the query parameter in DAX expression like in SSRS. Regarding query parameter, please see this article: Deep Dive into Query Parameters and Power BI Templates.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu