cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
blitwak Frequent Visitor
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
um_mir Frequent Visitor
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.
 
Capture1.PNGCapture2.PNGCapture3.PNG
 
 
Did I answer your question? Mark my post as a solution!
 
Regards
1 REPLY 1
um_mir Frequent Visitor
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.
 
Capture1.PNGCapture2.PNGCapture3.PNG
 
 
Did I answer your question? Mark my post as a solution!
 
Regards

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

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.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 109 members 1,539 guests
Please welcome our newest community members: