How do I achieve waterfall using matrix table or similar

[kavyav]

Hi Team,

Need your inputs if below viz can be achieved in PBI. Basically its week on week compare of Actual vs Target.

Below is the screenshot, interested in values in between the red lines. The yellow box represents Actuals. And immediate above blue box represents Target.. We read the data in the direction of 

[v-xiaotang · Accepted solution]

Hi @kavyav 

Thanks for reaching out to us.

to achieve this effect, you can  use conditional formatting, Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

when weekname= wk0, y=0, color=yellow,

weekname= wk1, y=1, color=yellow, y<1,color= blue,

weekname= wk2, y=2, color=yellow, y<2,color= blue,

weekname= wk3, y=3, color=yellow, y<3,color= blue,

etc.

Measure = 
var _row=MIN('Table'[Column1])
var _col=VALUE((RIGHT(MIN('Table'[Column2]),1)))
return  switch(true(),
_col=_row,"orange",
_col>_row,"light blue")

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@kavyav , You need to use Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Anal...

https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
https://www.youtube.com/watch?v=tuk1CrigTSI

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.