cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cassiopeia Frequent Visitor
Frequent Visitor

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:

 

grafik.png

 

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

3 REPLIES 3
Community Support Team
Community Support Team

Re: Use only full weeks in DAX

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.

5.PNG

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.

cassiopeia Frequent Visitor
Frequent Visitor

Re: Use only full weeks in DAX

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

cassiopeia Frequent Visitor
Frequent Visitor

Re: Use only full weeks in DAX

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 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors