Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello peeps,
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,
Julius
Hi @Anonymous ,
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.
Best Regards,
Xue Ding
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.
Hey Xue,
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..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |