Forum Discussion
zirael
3 years agoRegular Visitor
Date Hierarchy - keep continuous data upon expand
Hi,
In Power BI Desktop I need to replace the built-in auto date hierarchy with a custom one. With built-in date hierarchy I am getting what I need - data is still treated as continuous and x-axis i properly scaled.
When I do the same with a new calendar table marked as date and a new date hierarchy created I am getting:
what is I don't want. In this case only an the year level data is continuous:
When I expand through the date hierarchy to month it changes to categorical and I have no option to revert it.
New calendar table is defined as below:
Would you be able to help in order to get a result as on the first chart?
2 Replies
- amitchandakSuper User
zirael , Continuous is only possible with date and number data type
- ziraelRegular Visitor
Both conditions are met here