I have a quick problem. I have an external dateTable which I build for referencing.
Now I want to display data in line charts. By weeks, which looks like this:
I want the first and last week (in this case) to disappear. Simply, because there are not "full" weeks.
Since it is an "self-build" dateTable, I didn't find a workaround. In M this would be possbible, in DAX I dont know how.
All the best,
Hi @cassiopeia ,
You could try to change start and end of X axis in Format field. In this way, you don't need to create a formula. Values will be shown as what you set.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
apparently it's not dynamic anymore then. Therefore as soon as week 42 is over and week 43 is ongoing, this line chart becomes useless or has to be adjusted manually..
Maybe there is a way to NOT show the last few days if the week in it is not full?
I hope I am not overcomplicating this matter..
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!