SSAS Tabular Live Connections and Date Hierarchies

[FletchNZ]

Hi All,

I am currently looking at moving our enterprise reporting to PowerBi and I've spend the last day or 2 stuck trying to work out how to get Date hierachies to pull through to PowerBi so I have have some nice Year/month graphs etc.

After some more googling It looks like they are currently not supported and importing the data wont work as it is too large/PBI throws memory errors. Currently im using a Dax calculated table which is working well just not getting the result im after. 

So my question is, what is the best way/what does everyone use to work around getting "Year, month, date" and "Financial Year, Period" into powerbi and still look good?? 

[v-juanli-msft]

Hello

You could create report level measures like

Year= YEAR(MAX([date]))

Month= MONTH(MAX([date]))

Day=DAY(MAX([date]))

Best Regards

Maggie

[FletchNZ]

Hi, 

I'm not sure I follow, as far as im aware you cannot put measures on Axis of charts or make hierachies out of measures.

I have already have date/month/year/quarter/FinYear etc defined in a date table and even if I create a custom Year - Quarter field when I go to display it the ordering is all messed up and apply a sort doesnt fix it.

I've also researched building a custom sort but that doesnt seem to work when pulled through from a tabular model.

Thanks

Fletch