How to get Week Numbers to Display along with Date, Month & Year on a Stacked Column Chart?

[v-yilong-msft]

Hi @Anonymous ,

Your solution is great, @Uzi2019 . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

I create a table and use it in the Stacked column chart.

Then I choose New group. 

Then I get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019]

Hi @Anonymous 

Add your iso week number on 3rd level of hierarchy on X axis
Year > Month > ISO week > Date(day)

Then simply disable this property under X axis setting

I hope I answered your qeustion!

[Anonymous]

.

[Uzi2019 · Accepted solution]

Hi @Anonymous 
As you can see in my screenshot it displays all the level Year> Month > week > date
in your case you must have selected any month and year level in your chart hierarchy.

1) select all level up until you reach at year level

Like above then drill down to all level down untill it is grey out

I hope you would see simliar view as I am getting. somtime you have applied some filter so remove all those filter by check this option

Remove all the selected filter then check the result .

I hope I ansered your question!

[Anonymous]

.

[Uzi2019]

Hi @Anonymous 
Your welcome!