Forum Discussion

nzharsh's avatar
nzharsh
Frequent Visitor
9 years ago
Solved

Emulating SSRS Cell expression in Power BI

Considering the following screenshot from SSRS:   The box that is in RED has an expression which will eventually result in the below screenshot:     How can I emulate this in Power BI? ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi nzharsh,

     

    From images, it seems that the you use expressions to specify both matrix column group and values, right?

     

    In Power BI, we are not able to place any measures in Row Groups or Column Group of the matrix visual. So in your scenario, you need to transform data in Query Editor firstly to get a column field which contains "Week 1 09-Jan 2017", "Week 2 16-Jan 2017",etc and another column has value "Yes","No". You can take a look at this article about query editor: Common query tasks in Power BI Desktop.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi nzharsh,

 

From images, it seems that the you use expressions to specify both matrix column group and values, right?

 

In Power BI, we are not able to place any measures in Row Groups or Column Group of the matrix visual. So in your scenario, you need to transform data in Query Editor firstly to get a column field which contains "Week 1 09-Jan 2017", "Week 2 16-Jan 2017",etc and another column has value "Yes","No". You can take a look at this article about query editor: Common query tasks in Power BI Desktop.

 

Best Regards,
Qiuyun Yu