How to render Year-Month-Day Hierarchy as Date Data Type from SSAS Tabular live data source

Hi,

I'm trying to leverage the forecasting feature in Power BI for some of my reports, and one of the requirements is to have a Date value on the X-axis....

I am connecting to a SSAS Tabular cube via Live Connection, and have a Date dimension set up. My isssue is that the Year and Month fields are formatted as Text and don't lend themselves to be plotted on a line chart for forecasting.

I'm trying to create derived columns off my Actual Date field, which is of Date data type, and format the display in a way that I can create a hierarchy.

I'm not able to get the date to display as just "yyyy", and I'm not sure what other options to try.

Any suggestions?

Thanks,
Victor Rocca | www.victorrocca.com