Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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??
Hello
You could create report level measures like
Year= YEAR(MAX([date])) Month= MONTH(MAX([date])) Day=DAY(MAX([date]))
Best Regards
Maggie
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |