Dax on restricting or hiding values of particular week days.

[MhKT]

@amitchandak , @lbendlin , @MFelix @Greg_Deckler , @Morgana_2022 @Happy2023_05 @tamerj1 @daXtreme @Jihwan_Kim 

i am working on a line charts which gives information of measure value(avg of 7 days) on weekly basis(week start from mon-sun (ISO week)).

Now the issue is if a user is selecting any date (which falls under Thur, fri, sat & sun) then a particular line in chart is showing a sudden drop, this shouldn't be visible because it effects client a lot.

so my idea is, if user wants to know any data  (which falls under Thur, fri, sat & sun) then graph should end & show value of lastweek(previous week).

[amitchandak]

@MhKT , I have done blog to show values of weekend on Friday or Monday, See if that approach can help in this

https://amitchandak.medium.com/power-bi-show-weekend-data-on-monday-or-friday-dab5ee201f0e