Forum Discussion

UIUser's avatar
UIUser
Frequent Visitor
1 year ago

Make Year Disappear in Visual with Date Hierarchy

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 corre...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.