Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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)
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |