Cubes (SSAS) Date Filters and PowerBI

[chasedq]

Hello,

Our company is starting to use cubes a lot and one of the issues is date filtering. When we connect to the cube in SSAS the date field seems to be treated as string and not an actual field, thus losing the innate date filtering functionality (is on or before, is before, etc.)

After a bit of research, I was able to change the properties of the date attribute in the dimension by updating ValueColumn to Date datatype. 

Now I have two fields that come up in the list of attributes for the Date Dimension, one for Date (string) and one for Date.Value (date datatype). Needless to say, the Date.Value attribute shows the innate date filtering functions.

I just wanted to ask if this is by design? Is there a way to keep that just one date field but look at the ValueColumn instead of now having two fields? Is there another way to manage this?

Thank you!