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 t...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity 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