topic Re: SKYLINE Chart in Power BI Desktop in Desktop

SKYLINE Chart in Power BI Desktop

mim — Thu, 06 Oct 2016 03:58:19 GMT

Hi Guys

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

regards

Mim

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

Re: SKYLINE Chart in Power BI Desktop

ankitpatira — Fri, 29 Apr 2016 08:15:49 GMT

mim Consider options from custom visuals gallery.

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

Re: SKYLINE Chart in Power BI Desktop

mim — Fri, 29 Apr 2016 11:40:03 GMT

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 :)

Re: SKYLINE Chart in Power BI Desktop

Eric_Zhang — Wed, 04 May 2016 00:17:16 GMT

mim

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

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.

Re: SKYLINE Chart in Power BI Desktop

mim — Wed, 04 May 2016 00:51:47 GMT

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

Re: SKYLINE Chart in Power BI Desktop

mim — Sat, 12 Aug 2017 05:52:09 GMT

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

Re: SKYLINE Chart in Power BI Desktop

Anonymous — Thu, 01 Mar 2018 06:35:24 GMT

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

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

Hope it may suffice your requirement

Re: SKYLINE Chart in Power BI Desktop

mim — Tue, 15 May 2018 06:45:00 GMT

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

https://app.powerbi.com/view?r=eyJrIjoiMTY3MTdjZTUtYjE5Yi00NjdmLThiZTQtNTgxOGI2MmYyOWZjIiwidCI6ImI2ZWM3ZGYwLTc1ZGEtNDc2Ni04MGI0LWNlYzM1MzZlNGYzYSIsImMiOjEwfQ%3D%3D

Thanks PowerBI team.

Re: SKYLINE Chart in Power BI Desktop

katyhughes77 — Mon, 19 Aug 2019 22:06:47 GMT

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.

Re: SKYLINE Chart in Power BI Desktop

mim — Mon, 19 Aug 2019 22:52:15 GMT

katyhughes77 I am using matrix visual with some crazy DAX

Re: SKYLINE Chart in Power BI Desktop

RoughNeck — Wed, 18 Mar 2020 03:15:25 GMT

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!

Re: SKYLINE Chart in Power BI Desktop

mim — Wed, 18 Mar 2020 12:06:36 GMT

RoughNeck

pbix and Excel here

https://datamonkeysite.com/2016/10/05/completion-skyline-template/

Re: SKYLINE Chart in Power BI Desktop

RoughNeck — Fri, 20 Mar 2020 01:37:17 GMT

you are legend! thx a lot

Re: SKYLINE Chart in Power BI Desktop

Anonymous — Thu, 13 May 2021 02:23:32 GMT

You are a legend 🙂

Re: SKYLINE Chart in Power BI Desktop

Anonymous — Wed, 23 Jun 2021 06:22:04 GMT

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

Re: SKYLINE Chart in Power BI Desktop

Anonymous — Fri, 17 Sep 2021 00:51:16 GMT

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)

Re: SKYLINE Chart in Power BI Desktop

Anonymous — Thu, 27 Jan 2022 09:41:04 GMT

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

Re: SKYLINE Chart in Power BI Desktop

Anonymous — Thu, 03 Mar 2022 20:44:38 GMT

Hi Kathik

Is it possible to share your solution here about skyline chart

Thanks

Morteza

Re: SKYLINE Chart in Power BI Desktop

Anonymous — Fri, 11 Mar 2022 03:47:55 GMT

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

Re: SKYLINE Chart in Power BI Desktop

bzht12 — Fri, 17 Jun 2022 18:17:26 GMT

Great chart. How were you abel to re-rank the items when the slicer selection is changed?