cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

KPI visualization showing current week values with the ability of change of week

Hi,

I want to know if it possible to have a KPI that shows current week value when I open report but when changing week, update their value.

When we open our report take a look just for current iteration but when clicking in another week, update this value from that week.

I know that we can achieve this with edit interactions but I want that when I open my report, show just the value from current week, not sum of all weeks.

For instance:

Now, we are on iteration 2019w08 and we are selling umbreallas and our goal is 500 umbreallas per week.

Week and #

2019w06 - 321

2019w07 -  121

2019w08 -  711

Use case:

When open report, show 711 with goal 500

When clicking 2019w07, show 121 with goal 500

Current value:

When open report, show 711 + 121 + 321 with goal 500 + 500 +500

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

Re: KPI visualization showing current week values with the ability of change of week

Hi @blitwak

I hope below one of the solutions works for you.

Solution 1 : Create a measure like this

`CurrentWeek1 = LASTNONBLANK(Umbrealla[Sold],SUM(Umbrealla[Sold]))`
Solution 2: Create a index based on the Week number and then create a measure like this
```CurrentWeek2 =
VAR CurrentWeekIndex = MAX(Umbrealla[Index])
RETURN
CALCULATE(SUM(Umbrealla[Sold]),Umbrealla[Index]= CurrentWeekIndex)```
Both of the above solution return the same results. See below screen capture.

Regards
Frequent Visitor

Re: KPI visualization showing current week values with the ability of change of week

Hi @blitwak

I hope below one of the solutions works for you.

Solution 1 : Create a measure like this

`CurrentWeek1 = LASTNONBLANK(Umbrealla[Sold],SUM(Umbrealla[Sold]))`
Solution 2: Create a index based on the Week number and then create a measure like this
```CurrentWeek2 =
VAR CurrentWeekIndex = MAX(Umbrealla[Index])
RETURN
CALCULATE(SUM(Umbrealla[Sold]),Umbrealla[Index]= CurrentWeekIndex)```
Both of the above solution return the same results. See below screen capture.

Regards

Announcements

Community News & Announcements

Get your latest community news and announcements.

Power Platform Summit North America

Register by September 5 to save \$200

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 109 members 1,539 guests
Recent signins: