Forum Discussion
Help needed with complicated (?) waterfall chart
Not sure if a waterfall chart is the right visualization type. A table visual may be more useful.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi, thanks for your input.
I can only provide you with screenshots for now. The first screenshot shows what I'm supposed to create, but I'm not sure if it will be possible with Power Bi (I think it was created in Excel, possibly with stacked bars). I have found a solution on the internet, but I'm kind of stuck. The second screenshot shows what I have managed to create. As you can see the order of the categories is not correct, although I have used 'sort by column' and the index column I created for the categories. There seems to be something wrong with the values as well.
The third part shows the values I have used.
I might go with stacked bars if the waterfall doesn't work. I might have to check with the person that provided me the first screenshot.
1. Example of what I have to create
2. Example of what I managed so far
3. Script used to create the 'values'
Uren bridge =
Var Verlof = [Verlof (minus SU)]
Var WerkbareUren = [Werkbare uren]
Var Facturabel = [Facturabel]
Var DirectNietFacturabel = [Direct niet facturabel]
Var Indirect = [Indirect (ex verlof)]
Var Onderuren = [Onderuren]
RETURN
SWITCH(SELECTEDVALUE('Start bridge'[Index]),
1,
SWITCH(SELECTEDVALUE('Categorie uren'[Categorie]),
"Verlof", 1*Verlof,
"Werkbaar", 1*WerkbareUren,
"Facturabel", -1*Facturabel,
"Direct NF", -1*DirectNietFacturabel,
"Indirect", -1*Indirect,
"Onderuren", -1*Onderuren,
[Normuren]
),
2,
SWITCH(SELECTEDVALUE('Categorie uren'[Categorie]),
"Verlof", 0,
"Werkbaar", 0,
"Facturabel", 0,
"Direct NF", 0,
"Indirect", 0,
"Onderuren", 0,
[Gerealiseerd (ex verlof)]
)
)