Forum Discussion
Weekly In Progress waterfall trend & table
Hi All
I created a Weekwise InProgress trend graph for each buyer as per the steps shown below, this has been created by creating a new measure as following,
can you help me & share a way to create a waterfall graph to show the week over week change of InProgress? i.e. red if it is increasing & green if it is decreasing?
Steps for creating Weekly In Progress trend graph
1) Created a date table
2. Then created a measure.
Non RFx1 InProgress =
CALCULATE (
COUNTROWS ( 'Non RFx1' ),
FILTER (
'Non RFx1',
( 'Non RFx1'[req recvd dt NR] ) <= MAX('Calendar table'[Date])
&& ( 'Non RFx1'[Executed Date NR] ) >= MAX('Calendar table'[Date])
)
)
+ CALCULATE (
COUNTROWS ( 'Non RFx1' ),
FILTER (
'Non RFx1',
( 'Non RFx1'[req recvd dt NR] ) <= MAX('Calendar table'[Date])
&& ( 'Non RFx1'[NR Request Status] = "In Progress" )
)
)
3. Created a slicer using BuyerName and put the BuyerName to Filters on this page, then configure the BuyerName is not blank.
1) Now that I have the Weekly In Progress information, can you help me & share a way to create a waterfall graph to show the week over week change of InProgress? i.e. red if it is increasing & green if it is decreasing? I tried using waterfall & it is showing some weird results, it is not showing the week over week trend correctly.
2) Secondly, I also want to create a table/matrix as in the screenshot below as on overview. This table would just have Current week InProgress & last week InProgress. The next column should show the "change" week over week for each buyer instead of showing a "Total". Also if possible the change number could follow the conditional formatting of upwards error & red color if the week over week InProgress is increasing & green & downwards arrow if decreasing & yellow if no change.
Also, if theres an automatic way to just show last 2 weeks column always instead of me choosing it on the filters manually. (as I have done for week 27 & 28)
1 Reply
- amitchandakSuper User
aameen1515 , Check if this blog can help you