Forum Discussion

TimonMeyer's avatar
TimonMeyer
Frequent Visitor
8 years ago
Solved

Trend Visualization compared to previous week

Hi,   I try to visualize a change in a number (a sum of trucks per week) compared to the previous calender week.   For example...in Calendar Week 15 I counted 380 and in Calendar week 16 I counte...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    The myMax variable is essentially grabbing the current weeknum in the context of your visual. So, myMax - 1 essentially dials this back a week. So, if your current week is 16, when you are filtering for last week you want the rows where WeekNum is 15.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

The myMax variable is essentially grabbing the current weeknum in the context of your visual. So, myMax - 1 essentially dials this back a week. So, if your current week is 16, when you are filtering for last week you want the rows where WeekNum is 15.

TimonMeyer's avatar
TimonMeyer
Frequent Visitor
8 years ago

Thanks! I somehow managed to get the data right.

 

THX!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Timon,

     

    Could you please share the way you do this visual? I'm new to Power BI and what I'm trying to do is to put two numbers in comparison on one single card and show the variance aside, which is just what you did. 

     

    Thank you!

     

    Lexi

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Don't worry.

    I just realised how to work it out by myself.