0 Kudos

SSAS MD Live Connections, Between slicers and Default Members

Status: Accepted
by cwebb on ‎01-08-2018 06:10 AM

I am using a Live connection to SSAS Multidimensional in Power BI, and I have a Date dimension with a Date attribute on it that I want to use in a Slicer. I have set the ValueColumn property on my Date attribute in SSAS (similar to what is described here: https://community.powerbi.com/t5/Desktop/Cubes-SSAS-Date-Filters-and-PowerBI/td-p/43945)  and this allows me to use a Between slicer rather than just a regular List or Dropdown slicer. However if I also set the DefaultMember property on my Date attribute, the Between filter only allows me to select the single date that is the default member on the Date attribute and is therefore useless.

 

For example, without the DefaultMember property set, the Between slicer looks like this:

 

BetweenDefaultMemberNotSet.PNG

 

But with the DefaultMember property set to 3rd July 2001 on the Date attribute, the Between slicer only allows me to select that date:

 

BetweenDefaultMemberSet.PNG

Please fix this so the Between slicer starts off with the selection specified by the DefaultMember property but allows me to change this to select any member on my hierarchy!

 

Thanks,

 

Chris

Status: Accepted
Comments
by Moderator v-qiuyu-msft
on ‎01-10-2018 10:53 PM

Hi @cwebb,

 

I can reproduce this issue and already reported it internally: CRI 56515566. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

by Vicky_Song Established Member
on ‎01-10-2018 10:53 PM
Status changed to: Accepted
 
by Moderator v-qiuyu-msft
on ‎03-05-2018 06:37 PM

Hi @cwebb,

 

We will try to get a fix out for this by April. To work around the issue, you can manually in the text boxes select the dates he/she wants and set the range.

 

Best Regards,
Qiuyun Yu 

Idea Statuses