Using measures and filters to show two sets of data on a Power BI Radar Chart

  in  Microsoft Power BI

The Power BI Radar Chart is a nice way to show how a set of values varies across multiple categories. And you can add further sets - so one radar chart shows two or more sets of values against the spokes. You then see at a glance how the different sets of values compare.

I used the radar chart to compare ‘predicted’ and ‘actual’ attainment levels in different subjects for school students. The table of sample data is shown below. The attainment levels are in one column and the type - ‘Predicted’ or ‘Actual’ is in another column. I’m interested in the average predicted and the average actual attainment level for each subject category.

sample attainment data

Getting the two types of attainment level to appear as two different plots on the radar chart is straightforward. I created two measures:

predictions measure

actuals measure

The two measures, ‘Actuals’ and ‘Predictions’, are then used on the Y Axis within the Fields section of the Visualizations panel. The ‘Category’ field is set to ‘Subjects’. Here is the resulting radar chart:

sample enrolment data

The measures are simple - a good introduction to anyone who wants to start to do more with Power BI.


Related Posts

Why data analytics with Microsoft Power BI might just be great for your school

A first look at the UK HE longitudinal education outcomes dataset with Microsoft Power BI

Power BI in schools - a student performance dashboard

What's the difference between measures and calculated columns in Microsoft Power BI?

Slicer visualization in Power BI - filtering by date with help from a simple measure


High Quality Microsoft Power BI Training Courses

Find out how to build and share reports. Courses for complete beginners take you through data preparation, data loading, report design and basic calculated columns and measures. Bespoke courses can use your own data.