Forum Discussion
group by custom date
Hi, mikoal
You can check this tutorial on displaying dynamic date granularities via slicer selection.
Power BI - Dynamic Date Axis Granularity (Drilldown Alternative)
Kind Regards,
Ethan
Thanks Ethan, this video is very interesting.
2 questions.
1) The video shows day,month, year with specific ranges that falls into these categories. In my case it can show up like 97 days or 1023 days or 367 days. So for 367 days, would dynamic display as 1 year only?
2) The logic allows the user to view the charts at different increments (day, month,year). However since im using
SUMMARIZE(loadshape,"rowcount",CALCULATE(countrows(ALLSELECTED(loadshape)),ALLEXCEPT(loadshape,_Dimdate[Fiscal Year],loadshape[Premise])))
The allexcept requires a column of a date range to be returned, I'm not sure who that would even work. For eg: 367 days would require a column that encompasses 367 days. 5years would require a single period being 5 years long. in order to group it properly. At least this is my thinking.
If there is a different way of approaching this, please let me know.