Trasformation of dates

[ruserty]

Hello!

I made a querry to Google Analytics to shape graphs with data.

When I make a bar chart with traffic to our website, I put date (ddmm) as an x-axis, but when I put it as days, it shows data for 1Nov , 1 June etc in the same coloumn. The same is for same months of different years.

How do I change it?

Thank you!!

[MFelix]

Hi @ruserty,

You are using the date hierarchy correct? You need to use the Date as is in the visual options choose the date field and select Date instead of hierarchy.

Regards,

MFelix

[ruserty]

Thanks, but could you tell me if I can create custom hierarchy of dates by distinct weeks, quarters, years?

I want to be able to drill down them...

[v-caliao-msft]

@ruserty,

What you want is creating year, quarter, week hierarchy, which is cannot be done. Besause for difference years, weeks are belong to different months.

We can create Year, Quarter, Month and Day hierarchy. And when you add a date field to a visual in the Axis field bucket, Power BI automatically adds a time hierarchy that includes Year, Quarter, Month and Day

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11g-visual-hierarchies-drilli...

Regards,

Charlie Liao

[MFelix]

Hi @ruserty,

You can create the custom hierarchies in two ways click the ... on the column you want then choose New Hierarchy and the on the rest of the columns select Add to Hierarchy, or jus drag and drop the columns on top of each other:

Check also this tutorial: custom hierarchy

Regards,

MFelix