Forum Discussion

mim's avatar
mim
Icon for Advocate V rankAdvocate V
10 years ago
Solved

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

 

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

31 Replies

  • Samitha's avatar
    Samitha
    Frequent Visitor

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

     

     

    • bzht12's avatar
      bzht12
      Frequent Visitor

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

      • Samitha's avatar
        Samitha
        Frequent Visitor

        This is being one of the products i have developed. Can contact me on [email protected] if you need any further info

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Samitha;

      Can be able to share the custom visual, here is my email [email protected]

      • Samitha's avatar
        Samitha
        Frequent Visitor

        This is being one of the products i have developed. Can contact me on [email protected] if you need any further info

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee

    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.

    • mim's avatar
      mim
      Icon for Advocate V rankAdvocate V

      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's avatar
        mim
        Icon for Advocate V rankAdvocate V

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

  • AWPBI's avatar
    AWPBI
    Regular Visitor

    There is a Skyline visual in Power BI AppSource.

     

     

    • mim's avatar
      mim
      Icon for Advocate V rankAdvocate V

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

  • Anonymous's avatar
    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's avatar
      Anonymous
      Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Kathik

      Is it possible to share your solution here about skyline chart

      Thanks

      Morteza

    • Anonymous's avatar
      Anonymous
      Not applicable

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