Forum Discussion

Andwu's avatar
Andwu
Icon for Helper I rankHelper I
9 years ago
Solved

Apply Filter on Date Aggregation (3M, 6M, MAT)

I have connected my Power BI Desktop to an SSAS Server (2014). The data model has a date aggregation dimension with the following values (MAT, 3M, 6M, None, YTD). I'd like to create the following vis...
Need Help
  • Andwu's avatar
    Andwu
    9 years ago

    Unfortunately I do not know the specification of the cube. However I installed the latest version of Power BI Desktop and now I can set the filter as planned by marking the appropiate Date aggregations by holding CTRL. So my primary request has been solved.

     

    Thanks

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

Hi Andwu,

 

How did you define the date aggregation dimension and values (MAT, 3M, 6M, None, YTD)? Please share some screenshots about the report if possible.

 

Best Regards,
Qiuyun Yu