Forum Discussion
Continuous X-Axis with Custom Date Hierarchy
Hi Anonymous ，
I have a new idea: create four columns:Year ,Quarter, Month,Day,using the following dax expressions:
Year = YEAR('Table'[TimeStamp])Quarter = QUARTER('Table'[TimeStamp])Month = MONTH('Table'[TimeStamp])Day = DAY('Table'[TimeStamp])Then create a line chart without using date hierarchy,and put all the columns in X-axis:
And you will see:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
v-kelly-msft sorry for the delayed response. This drillthrough workaround is not going to work for me because I need to have several visuals on a single page and having to drillthrough on each of them is going to create a large amount of extra visuals. If there was a way to do the reverse of your suggestion and have a date hierarchy with a drillthrough into the actual timestamp, that may work as there is only one extra visual, but I do not believe this is possible. I am really hoping Power BI will add a continuous X-Axis when using a custom date hierarchy.
Community SupportHi Anonymous ，
I have a new idea: create four columns:Year ,Quarter, Month,Day,using the following dax expressions:
Year = YEAR('Table'[TimeStamp])Quarter = QUARTER('Table'[TimeStamp])Month = MONTH('Table'[TimeStamp])Day = DAY('Table'[TimeStamp])
Then create a line chart without using date hierarchy,and put all the columns in X-axis:
And you will see:
Kelly