Forum Discussion

AbdulMukhtar's avatar
AbdulMukhtar
Frequent Visitor
9 years ago
Solved

Default member issue

I am trying to create Power BI desktop report from SSAS database using Live connection method. current month is defined as default member for date dimension in the cube. when i drag year attribut...
  • Ethernet_Jack's avatar
    Ethernet_Jack
    9 years ago

    I had the same issue and it was making me bonkers. Our cube had a default set for date for yesterday. The key was that the default was set at the lowest level of our date heirarchy. So I added a report filter at the bottom and used advanced filter on the lowest level of our heirarchy to say "DATE contains '20'.  That will pull everything this century, which covers the whole cube.  Then I could use other elements of the heirarchy to slice into quarters/years/ whatever.  I think this is still a silly roadblock that PowerBI needs to sort out, (and putting dates in date order instead of integer order), but at least the work around was easy.

     

    Hope that helps!

AbdulMukhtar's avatar
AbdulMukhtar
Frequent Visitor
9 years ago

Hi Micheal_Shao,

 

Thanks for the reply.

 

How can i get it to work in power bi?

 

I am trying following things:

1) Year wise sales graph (Currently : It is showing only current year)

2) When user clicks on year, it should drill down to Quarter wise sales and when we click on Quarter it should show monthwise sales.(Currently : When we click on current year it is showing current quarter and when we click on quarter it is showing current month. We think it is because of default member which we have set for month attribute to current month.

 

Thanks

 

 

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi AbdulMukhtar,

 

Well, I am not sure what the data hierarchy looks like, just from my view, I would try to remove the default member settings.

Another approach that should work is to set the month in the Year-Quator-month hierarchy to be the default member (so if year is selected this time, it will query the year data and ingore the default member configuration), which need to alter the data hierarchy at the data source side.

Regards