Forum Discussion

mattkarriker's avatar
mattkarriker
Icon for Helper I rankHelper I
9 years ago

SSAS Calculated Dimension members Miltidimensional

Good day Forum I am running into an issue.  I want to be able to Dynamically set PowerBI reports to filter to the current month.  My data source is a live connetion to SSAS MultiDimensional model.  ...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

mattkarriker

 

As mentioned in document:

 

Multidimensional model expose calculated members on attribute hierarchies as values of a column. 

 

I don't think there's any solution other than creating "Calculated members on user hierarchies". Please sumbit your feedback on idea.

 

Regards,

 

 

tannera's avatar
tannera
Icon for Advocate II rankAdvocate II
9 years ago

Have you tried using the numeric slicer that is in 'Preview' at the moment?

 

Go to Options -> Preview features -> tick 'Numeric range slicer'.

 

Add the 'Slicer' visualization to your page, with a Date dimension as field. Click on the downwards arrow that is on the header and select 'Relative'. Then set the relative filter to 'This - Month'.