Forum Discussion

Gaborfromungarn's avatar
4 years ago

Waterfall Chart

Hi all,

I am trying to recreate this from a ppt in PowerBI

 

I would like to have 2 Year quarter selector.
1 for the starting period 
1 for the end period

Does anyone know how to do it?
This is my value measure:

Switch NSV =
if(ISCROSSFILTERED('KPI'[Switch]), Switch ( True(),
Values('KPI'[Switch]) = "YoY", 'Measures (2)'[Sum NSV],
Values('KPI'[Switch]) = "YTD", [YTD],
blank()), blank())


This is my Year quarter colum:
'Date Table'[Financial Year - Quarter]


Thank you for your help!