Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
But with the DefaultMember property set to 3rd July 2001 on the Date attribute, the Between slicer only allows me to select that date:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.