Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
2 years later, and PowerBI has finaly conditional formating in matrix, I managed to have a nice skyline.
Thanks PowerBI team.
Great chart. How were you abel to re-rank the items when the slicer selection is changed?
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.
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!
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)
you are legend! thx a lot
@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 🙂
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |