Forum Discussion
X-axis format option
Hi there,
I have data in which the regulatory year starts from 1st April of every year and ends on 31st March of next year. In other words, it starts on Week number 14 of a year and ends at Week number 13 of next year. I want to plot data where x-axis contains the week number. The problem is that I can start the x-axis value from 14 using the x-axis format option but I can't show 13 at the end of the x-axis as the last value of x-axis. Is there any way of doing that?????
Dunner2020 , For that You should create YYYY WW and use that
Year Week = Year([Date])*100 + WEEKDAY([Date],2) // For Monday Week Or WEEKDAY([Date],1)
You can use that. Or You can Create FY Week. https://www.youtube.com/watch?v=euIC0dgGTNM
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
2 Replies
Dunner2020 , For that You should create YYYY WW and use that
Year Week = Year([Date])*100 + WEEKDAY([Date],2) // For Monday Week Or WEEKDAY([Date],1)
You can use that. Or You can Create FY Week. https://www.youtube.com/watch?v=euIC0dgGTNM
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.amitchandak , But what if I wants to display the previous and current year data on the same graph wih x-axis contains weekend ???
