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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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

30 REPLIES 30
Samitha
Frequent Visitor

 I have made a custom visual to generate Skyline chart in power BI

 

 

2022-09-05 18_31_59-skyline2 - Power BI Desktop.png

Could you please help me create a Skyline in Power BI?

 

I need exactly the same as you have created

Hi Samitha, Do I have any chance to have it?

blotfinia@gmail.com

Hi,

I am looking to build a skyline chart as per the one posted below. This is my attempt at it using a matrix visual. I would like to have some help to improve on it. I definitely would like to add more info on the cells and further conditioning.

bengef_0-1679968507990.png

 

Can you please share the PBI file  @ kam464@gmail.com.

 

Appreciate your support.

Hi Samitha;

Can be able to share the custom visual, here is my email les88gon@gmail.com

This is being one of the products i have developed. Can contact me on sam1981_phs@live.com if you need any further info

Nice.  Is it on the Marketplace yet? If so, what is the name of this custom visual?

This is being one of the products i have developed. Can contact me on sam1981_phs@live.com if you need any further info

Thats great.

I am trying this to make for long time but could not able to make one.

 

Can you please share the native file please.

thankyou.

Anonymous
Not applicable

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

Anonymous
Not applicable

Hi @Anonymous ,
Can help to share how you did your skyline chart. Thanks

Anonymous
Not applicable

Hi Kathik

Is it possible to share your solution here about skyline chart

Thanks

Morteza

Dear Karthik, I am really interested in your Power BI file. Can you share it?

Anonymous
Not applicable

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
Employee
Employee

@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

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

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.

 

 

Could you please help me create a Skyline in Power BI?

 

I need exactly the same as you have created... 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.