Forum Discussion

aameen1515's avatar
aameen1515
Helper I
6 years ago

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)