Forum Discussion
Helper ISet max for y-axis scale in Radar Chart
Hi there! I'm using the Radar chart visual, and just can't find a way to fix the max value of the y-axis. This is key for me to be able to compare across data (I have a table with employees and their proficiency across 5 different skill categories, ranking 0-5). I have to be able to slice through the data, and when I do so I have 2 issues:
-the scale in the y-axis changes according to the data selected in the slicer; I need the max value to always be 5.
-the order the 5 categories dislpay also changes.
Any Ideas?
Hi Ewenardus ,
Based on your question, we tried a lot of radar vision objects, unfortunately, at present there are still some limitations in trying to fix the maximum range on the radar vision object, it is dynamically changing and can not be set up by yourself, we tried to find a similar radar vision map that can help you to realize a similar effect!This visual object is not able to do the outermost layer of 5, but still fixes the five as the boundary, I hope this alternative can help you, I hope you can understand!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
14 Replies
- FarhanJeelani
Super User
Hi Ewenardus ,
To address your issues with the Radar chart visual, here’s what you can do:
Fixing the Y-Axis Scale:
Set a Fixed Maximum Value for the Y-Axis:
- Go to the Format pane of the Radar chart visual.
- Under the Y-Axis settings, look for the option to set the maximum value.
- Manually set the maximum value to 5.
- This will prevent the y-axis from dynamically adjusting based on the data selected in the slicer.
Ensure Consistent Order for Categories:
- Create a Custom Sort Order:
- In your data table, add a new column specifying the desired order of your skill categories (e.g., 1 for "Skill A", 2 for "Skill B", etc.).
- In Power BI, go to the Data View, select the column for your skill categories, and set the Sort By Column property to your new order column.
- This ensures that the categories display in a fixed order, regardless of slicer selection.
- Create a Custom Sort Order:
Please mark this as solution if it helps you. Appreciate Kudos.
EwenardusThanks for your quick response.
On the y-axis part, that's the thing, I'm not seeing that option you mention:
What am I missing here?
I'll try what you say about the order!- FarhanJeelani
Hi Ewenardus ,
Please select format tab instead of data tab.
Please mark this as solution if it helps you. Appreciate Kudos.
Hi Ewenardus ,
Based on your question, we tried a lot of radar vision objects, unfortunately, at present there are still some limitations in trying to fix the maximum range on the radar vision object, it is dynamically changing and can not be set up by yourself, we tried to find a similar radar vision map that can help you to realize a similar effect!This visual object is not able to do the outermost layer of 5, but still fixes the five as the boundary, I hope this alternative can help you, I hope you can understand!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Ewenardus
Hi Anonymous thanks so much for your post - this has solved my issue!
One more thing, you might see extra columns on your Radar Axis.
Go in filters pane and make your data(in my example:Result) as "Is Not Blank"
Hi Ewenardus ,
There is a way around for this problem in Radar Chart.
My data to visualise on Radar Chart was 'Result'.- Remove “Result” from the Y Axis (because the last value appears at the top).
- Create a measure called Max Result = 100 and place that on the Y Axis.
- Re-add “Result” to the Y Axis.
- In the Format Pane → Visual, assign a light grey color (#E6E6E6) to “Max Result.” You can also match the measure’s color to your background if you want it hidden.
I hope this solves your issue!
Best Regards,
AreebPlease mark this as the solution if it helps.
It's a little wanky, but I've created a measure called RADARMAX with the value I wanted to be my max and added to the visual as a secondary Y Axys value.
