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

[JohnJoe123]

Hi Everyone,

Here is a Google Drive Link to my Power BI File:

https://drive.google.com/file/d/1j4_sAiBrfIX673pbZsXRR_t-ARgc2WuK/view?usp=drive_link

I workin a Factory that makes Microchips.

The Machine that Processes / Manufactures these Microchips is called ISP.

I'm currently looking at the Running Time of the ISP Machine versus the Down Time of the ISP Machine on each Calendar Date.

I obtain all of this information from a MySQL Relational Database (Amazon Redshift - AWS) and I wrote the SQL Script to Construct my Power BI Query and its various fields. (Including a Date Field and an ISO Week Number Field)

Below is an image of my current graph:

This Stacked Column Chart on the X-Axis shows the Calendar Date, Month and Year.

However, I would also like to Display the ISO Week Number of the Year.

I would like something like the below: (I made the below Image in PowerPoint)

Is the Desired Result shown in the Image Above Possible?

I do already have an ISO Week Number field in my Power BI Query, but when I add it to this Chart's X-Axis, I get the following Result:

[v-yilong-msft]

Hi @JohnJoe123 ,

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 @JohnJoe123 

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!

[JohnJoe123]

Hi,

Thank you for this,

However, when I try this, it displays the Date and Week Number, but not the Month and Year.

I understand that it display the Year after the Week Number - but I'd like the Year listed Separately at the lowermost level of the X-Axis.

I'd like it to show all of the following:

- Calendar Date

- ISO Week Number

- Month

- Year

[Uzi2019 · Accepted solution]

Hi @JohnJoe123 
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!

[JohnJoe123]

Thank you so much!

After I applied the help from your first post, I then followed the instructions from your second post - and I achieved the desired result!

[Uzi2019]

Hi @JohnJoe123 
Your welcome!