Make Year Disappear in Visual with Date Hierarchy

[UIUser]

Hi, 

I have Calender Week and Year on the X axis. Is there a way to make the year disappear (format white or so)?

I only want to see CW. I need the year however on the axis for correct sorting. Otherwise it would put CW 52 at the end but it is actually the last week of the prior year. 

Thanks!

[v-nmadadi-msft]

Hi @UIUser 
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks 

[v-nmadadi-msft]

Hi @UIUser 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @UIUser ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Karsurya12_03]

Hi @UIUser ,

weeksort = 
var __year=YEAR(Query1[DayDate])
var Result = __Year& FORMAT(WEEKNUM(query1[Daydate]),"00")
RETURN
Result create one calculated column for sorting

You can create one calculated column for sorting, and remove year from x-axis

Thanks & Regards,

Surya.

[Karsurya12_03]

Hi @UIUser ,

weeksort = 
var __year=YEAR(Query1[DayDate])
var Result = __Year& FORMAT(WEEKNUM(query1[Daydate]),"00")
RETURN
Result create one calculated column for sorting

You can create one calculated column for sorting, and remove year from x-axis

Thanks & Regards,

Surya.

[Anonymous]

HI @UIUser,

Any update on this? Did these suggestions help for your scenario?

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @UIUser ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[danextian]

Hi @UIUser 

You can create a calculated column that returns invisible characters and use it  in the hierarchy instead.

Example:

Invisible Year =
REPT ( UNICHAR ( 8203 ), datestable[year] )

[ToddChitt]

That's not going to be easy. You can use the Sort By column specification and maybe specify that 52 is sorted before 1 and 2 and 3, etc., but that only works if that is all the data you have. Power BI wouldn't figure out, for example, that week 52 of 2025 should be sorted at the end instead of the beginning. So you would need to limit your date dimension to ONLY weeks 52 through 51 (52, 1, 2, ... 50, 51).

Let me ask this: WHY do you need to remove the year from the x axis?