Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Ewenardus
Helper I
Helper I

Set 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?

1 ACCEPTED SOLUTION
v-xingshen-msft
Community Support
Community Support

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!

vxingshenmsft_0-1736745814073.png

vxingshenmsft_1-1736745832973.png

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 Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

12 REPLIES 12
areeb_kanwar
Frequent Visitor

Hi @Ewenardus ,

There is a way around for this problem in Radar Chart.

areeb_kanwar_0-1739396924107.png
My data to visualise on Radar Chart was 'Result'.

  1. Remove “Result” from the Y Axis (because the last value appears at the top).
  2. Create a measure called Max Result = 100 and place that on the Y Axis.
  3. Re-add “Result” to the Y Axis.
  4. 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,
Areeb

Please mark this as the solution if it helps.

v-xingshen-msft
Community Support
Community Support

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!

vxingshenmsft_0-1736745814073.png

vxingshenmsft_1-1736745832973.png

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 Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

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 @v-xingshen-msft thanks so much for your post - this has solved my issue!

FarhanJeelani
Super User
Super User

Hi @Ewenardus ,

To address your issues with the Radar chart visual, here’s what you can do:

Fixing the Y-Axis Scale:

  1. 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.
  2. 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.

Please mark this as solution if it helps you. Appreciate Kudos.

Thanks for your quick response.

 

On the y-axis part, that's the thing, I'm not seeing that option you mention:

Ewenardus_0-1736451903827.pngEwenardus_1-1736451918444.pngEwenardus_2-1736451930124.png

What am I missing here?

I'll try what you say about the order!

Hi @Ewenardus ,

 

Please select format tab instead of data tab.

FarhanJeelani_0-1736452525771.jpeg

Please mark this as solution if it helps you. Appreciate Kudos.

So, I'm using the Radar Chart 3.1.3.0 visualization

Ewenardus_0-1736453350455.png

And this is what I see:

Ewenardus_1-1736453402187.png


No x or y axis.

This is my graph:

Ewenardus_2-1736453446613.png

As you can see, that top value is between 1 and 2, but it's on the external line (which I want to be 5).

Hi,

Use the standrd radar chart visual (not the custom visual which you are referring to)


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @Ashish_Mathur thanks for your response!

 

Sorry but which is the standard radar chart you are referring to?

Sorry i was mistaken.  Please ignore my post.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Ok, thanks anyway!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.