Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
My final objective it's got a graphic like that. The posibilities of the waterfall visual from PBI don't give me all the requests.
So, I try to do through excel to explain my proposal.
I have a dataset like that:
Fgstnr | STATUS |
vxz | B |
vji | B |
fdf | B |
fsr | B |
ghf | C |
uiu | C |
iyr | D |
kjh | D |
yuk | D |
oiu | E |
If the status A is the sum of the rest of the status, I can get that table:
VALOR | CATEGORIA |
10 | A |
4 | B |
2 | C |
3 | D |
1 | E |
So, finally I need a measure to get a table like that and the graphic.
I share the set of data, and the excel to describe the process.
https://drive.google.com/drive/folders/1uoBKZ0sXVEPV-Q0sQTflfLzfnIURP3xv?usp=share_link
Thank you very much for your time!
Solved! Go to Solution.
Hello @MTrullàs,
Here is my proposal on how to solve your problem.
Step 1. We create a new table with statuses to add an "A" and link it with the existing one.
Step 2. We create 4 x 2 = 8 measures like these:
Step 3. We put them in the right order and adjust the color scheme.
Voila:
Here is the PBIX with this solution - https://www.dropbox.com/s/apyam106gi5z0id/pbi-custom-waterfall.pbix?dl=0
If it is vitally important that the color of the A column matches the color of the "active" segments in all other columns, the measures must be tweaked and become more complicated.
Hello @MTrullàs,
Here is my proposal on how to solve your problem.
Step 1. We create a new table with statuses to add an "A" and link it with the existing one.
Step 2. We create 4 x 2 = 8 measures like these:
Step 3. We put them in the right order and adjust the color scheme.
Voila:
Here is the PBIX with this solution - https://www.dropbox.com/s/apyam106gi5z0id/pbi-custom-waterfall.pbix?dl=0
If it is vitally important that the color of the A column matches the color of the "active" segments in all other columns, the measures must be tweaked and become more complicated.
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |