Need help: dynamic dashboard

[Anonymous]

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 · Accepted solution]

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)