Forum Discussion
FrugalEconomist
9 years agoHelper III
Finicky Fiscal Year Sorting
Dear Power BI Community, As always, thank you for your helpful responses. I'm having trouble now presenting my data in a custom end of year. I believe my DAX calculated formula is correct, but t...
FrugalEconomist
9 years agoHelper III
Thanks a68tbird.
Thanks for your feedback, but unfortunately it doesn't work because the 'canned' power bi date hierarchy can drill down date type fields into Year, Quarter, Month, and Day. However when I create custom columns, even though I've made the date to date join, it doesn't recognize any of the calcluated columns or measures for some reason :(
a68tbird
9 years agoResolver II
How about in the visulization settings. Under the X-Axis setting, you can set Start and End dates.
- FrugalEconomist9 years agoHelper III
What!?!? That's so cool, but it doesn't show up for me :(
I also cannot change the data type to continuous.