Weekly In Progress waterfall trend & table

[aameen1515]

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)

[amitchandak]

@aameen1515 , Check if this blog can help you

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...