James Swinburne on 19 Nov 2016 11:10:51
When I use a live connection to SSAS MD and, for example, pull the year attribute from a date hierarchy into a visual, it formats as 2,016 as opposed to 2016.
This suggests to me that PowerBI doesn't recognise date dimensions in a way that would benefit from intelligent filtering options like 'last x years' and appropriate formatting.
- Comments (1)
Comments (1)
RE: PowerBI does not recognise SSAS date hierarchies as dates
This is one of the features which are expected to work out of the box. Currently it is not possible to use a hierarchy based on a date dimension and use a continous axis on the date level.