Forum Discussion
Default member issue
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!
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!