Date axis is not working as expected

[Anonymous]

Hi, I am trying to replicate a graph from a old dashboard, where the x- axis is split into week, date and then the day of the week.

FY20-17 signifies financial year 20 and week 17.

I am trying to put together the same visual with the same feilds, but unable to get the split of x-axis as show above into week--> date--> day instead it's giving me a graph as shown below and then I am able to drill down but that doesn't give the categorization of the x-axis as above.

I tried creating a week heirarchy but , it still isn't working.

Let me know if there is a better way to do it.

Thank You.

[v-lid-msft]

Hi @Anonymous ,

We can try to make a Hierachy field by dragging date field into year-week field, than use this a s the x-axis.

BTW, pbix as attached.

Best regards,

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more

[MFelix]

Hi @Anonymous ,

If you are using the same fields as in the previous chart, check:

• X-axis is categorical or continuous
• Have make the full drill down on the x-axis is the last arrow on the options of the chart (https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill)
• The X-axis is concatenated or not

Regards,

MFelix