Forum Discussion
Helper IIPower BI - Spider Diagram Visual
Good afternoon,
I am struggling to recreate a visual that is possible to create in Excel on Powerbi.
I need to be able to visualise different sets of data on a spider diagram, with different percentages being coloured red, orange, yellow, green etc to express the level of maturity of the dataset (i.e Green is good)
Really struggling to reproduce it in Powerbi, and unsure if i can embed the excel graphic in some how?
Appreciate any help you may be able to give
Josh
9 Replies
LED_GeneralAdvocate I
I think the Radar Chart is what you are looking for:
Radar Chart
Josh1994Appreciate your feedback, unless i am using it correctly i am unable to display my resuults as lines, and the colours as not lines at the same time 😞
- Josh1994
The problem i really struggle with is getting the coloured background ranges 😕
Strange it is so easy in excel but so difficutl in power Bi ( for me anywasy)
v-menakakotaCommunity Support
Hi Josh1994 ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Yes, it is possible to create a spider (radar) chart in Power BI with coloured background ranges to represent maturity levels, though it requires some workarounds since Power BI's native radar chart doesn't fully support this out of the box like Excel does.
Please consider using Power BI's DAX to calculate maturity levels and a combination of line charts with filled areas to approximate the spider chart effect. This is more complex but offers more control.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.- v-menakakota
Hi Josh1994 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you