Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help: dynamic dashboard

Hello,

 

I'm working on a dashboard where I want to include graphs that shows progression over time, as well as KPI's for the highest selected week.

 

So for the example herebelow it means I want all highlighted KPI's to give the values of week 41, right now it is giving me averages of the selected period. What modifications to the KPI's should be made in order to reach this?

Would really appreciate help, thanks

 

  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    I think you are talking about a report here, not a true Power BI Dashboard, correct?

     

    If I understand what you are going for, what you generally do is to create something like an IsCurrentWeek flag and filter your KPI or measure to that, so something like:

     

    Column = IF('Table'[Weeknum]=WEEKNUM(TODAY()),1,0)

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    I think you are talking about a report here, not a true Power BI Dashboard, correct?

     

    If I understand what you are going for, what you generally do is to create something like an IsCurrentWeek flag and filter your KPI or measure to that, so something like:

     

    Column = IF('Table'[Weeknum]=WEEKNUM(TODAY()),1,0)