Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NeilB79
Frequent Visitor

Help creating a 'Crocodile' Chart

Hi all,

 

We use a chart we call the crocodile chart to visualise risk around our forecast. There are catagories (say AAA, BBB, through to EEE) which we roll up our upside and downside risks into. We rank the catagories impacts on the chart (so AAA might be top ranked downside, but DDD might be top ranked upside and so not aligned on chart - see example below).

I build it in Excel with some tricks (ranks, blank bars, line charts for labels) but want to move into PowerBI for automatic updating / filtering etc. 

I have no idea! See below for a simple example data set and output chart. Appreciate any help or pointers to get it going.

NeilB79_0-1713870971654.png

 





4 REPLIES 4
Uzi2019
Super User
Super User

Hi @NeilB79 

I found similar looking visual. not sure how well it will aligned with your problem statement.

Uzi2019_0-1713873140228.png

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Thanks, unfortunately that doesnt deliver what I am after, its a rotated waterfall.

 

Uzi2019
Super User
Super User

Hi @NeilB79 

You can use 2 water fall chart to create similar look with some adjustment.

 

Uzi2019_0-1713871187718.png

 

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Hi @Uzi2019  - thanks - how would you suggest I stack waterfall charts together into a single chart? Not sure I can see a path towards getting something like what I am after.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.