Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Use only full weeks in DAX

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

Need Help

3 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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..

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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..

         

        v-xuding-msft