cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mim
Advocate V
Advocate V

SKYLINE Chart in Power BI Desktop

Hi Guys

 

is it possible to show a skyline chart in Power BI, i am attaching a sample example

 

regards

Mim

 

skyline.jpg

edit : i end up creating the chart in Excel, using RNKX and pivot conditional formating, i made a template available here 

1 ACCEPTED SOLUTION
mim
Advocate V
Advocate V

2 years later, and PowerBI has finaly conditional formating in matrix,  I managed to have a nice skyline.

 

https://app.powerbi.com/view?r=eyJrIjoiMTY3MTdjZTUtYjE5Yi00NjdmLThiZTQtNTgxOGI2MmYyOWZjIiwidCI6ImI2Z...

 

Thanks PowerBI team.

 

 

View solution in original post

15 REPLIES 15
KarthikKV
Helper V
Helper V

Hello everyone,

 

After lot of research I was able to implement Skyline chart using matrix visual, its really looking good. 

 

Please do contact me if anyone needs help.

 

Thanks,

Karthik

apanasara
Frequent Visitor

Please refer git for Char-in-Chart Rendering into skyline

GitHub: https://github.com/apanasara/skyline-chart

 

Chart-in-Chart.jpg

 

Legend List.JPG

 

Hope it may suffice your requirement

Eric_Zhang
Microsoft
Microsoft

@mim

AFAIK, there's no "skyline" in PowerBI, however the stacked column chart shows similarly as yours.
Capture.PNG

 

The categories are differentiated by different colors and the height each color indicates the percentage.

 

If that difference really matters, you can submit your feedback on PowerBI Ideas.

Thanks Eric

 

i will add an idea for that, in the mean time time, i manage to find a way to do in excel using cube formula and conditional formating

mim
Advocate V
Advocate V

one year later and still i could not find a solution using PowerBI 😞

mim
Advocate V
Advocate V

2 years later, and PowerBI has finaly conditional formating in matrix,  I managed to have a nice skyline.

 

https://app.powerbi.com/view?r=eyJrIjoiMTY3MTdjZTUtYjE5Yi00NjdmLThiZTQtNTgxOGI2MmYyOWZjIiwidCI6ImI2Z...

 

Thanks PowerBI team.

 

 

View solution in original post

You are a legend 🙂

@mim What visualization did you use for your skyline in BI? Your example is exactly what I'm looking to create, but the closest thing I see in BI is the stacked column chart. 

@katyhughes77  I am using matrix visual with some crazy DAX

RoughNeck
Regular Visitor

hey mim,

are you able to share the the crazy DAX? or share the whole PBIX file?

it looks nice and planning to do the same.

thanks a lot!

M20_PJ
Regular Visitor

Hey Mim, Thanks, your .pbix file helped me.

 

I have a question, is it possible to modify the DAX in "Skyline Subsystem" to make it works for in-active relationship since in my case i have more than one date (in yours, you only have "Forecast" date column to be refered)

RoughNeck
Regular Visitor

you are legend! thx a lot

ankitpatira
Community Champion
Community Champion

@mim Consider options from custom visuals gallery. 

 

https://app.powerbi.com/visuals/

 

 

 @ankitpatira  I had a look there first, could not find anything.

 

a skyline is basically  a clustered Stacked Bar chart but all the value show the same "lenght", the difference is captured by conditional formating.

 

it is a popular chart in construction, and i wanted to use it as an excuse to introduce power bi to my workplace 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.