Forum Discussion
Radar chart for beginner
Hi all. I am a complete novice at BI, just started on Sunday but have a working dashboard that i am reasonably happy with. However, I have a question (well i have several but one at a time)
Radar chart.
I have two columns of data in my dataset, column A is category, car, bike, boat as examples, column B is made up of values (red, green, blue) as an example.
What i want to do is to have a radar chart that effectively allows me to visualise how many red cars, bikes, and boats on a radar chart as one example. My data does not have numeric values so i cant count them as such. Is there a way of using the MS radar to have the 3 cateories around the outside of the radar (i.e. the 3 points) and to count how many 'red' there are for each. Ideally i will put a slicer on the dashboard for each colour. Hope that makes sense.
thanks
Hi,scottda4270
Regarding the issue you raised, my solution is as follows:
- First I created the following table based on your description:
2.Next please select the view to download Radar view:
3.I then created the following measure:
Measure = CALCULATE(COUNTROWS('radartable'),FILTER(ALLSELECTED('radartable'),'radartable'[category]=MAX('radartable'[category])&&'radartable'[value]=MAX('radartable'[value])))4.Here's my final result, which I hope meets your requirements.
Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- First I created the following table based on your description:
Hi Anonymous @thank you so much. This is exactly what I was trying to do. I have not used Measures before so I don't understand the syntax of your solution so I may have to do some reading up. I did manage to find a workaround but it's not as elegant as yours. I added additional columns in my dataset for each colour. I then wrote an IF statement to populate each row with a 1 or 0 based on condition. It works, but I like your solution better. Thanks again
2 Replies
Hi,scottda4270
Regarding the issue you raised, my solution is as follows:
- First I created the following table based on your description:
2.Next please select the view to download Radar view:
3.I then created the following measure:
Measure = CALCULATE(COUNTROWS('radartable'),FILTER(ALLSELECTED('radartable'),'radartable'[category]=MAX('radartable'[category])&&'radartable'[value]=MAX('radartable'[value])))4.Here's my final result, which I hope meets your requirements.
Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous @thank you so much. This is exactly what I was trying to do. I have not used Measures before so I don't understand the syntax of your solution so I may have to do some reading up. I did manage to find a workaround but it's not as elegant as yours. I added additional columns in my dataset for each colour. I then wrote an IF statement to populate each row with a 1 or 0 based on condition. It works, but I like your solution better. Thanks again
- First I created the following table based on your description: