Fixed category values in radar chart visual in presence of other slicers

[uni_student]

Hello,

I have some industrial data consisting of 4 columns.

Here, the source denotes the name of the alarm, the timestamp shows the exact time the alarm occured, the area shows the area of the plant from whic the alarm originated. The time range is a calculated column which acts as the category axis for the radar chart. If the alarm occurs between 1 PM and 2 PM, the time range is 1 PM - 2 PM and so on.

My full dataset has alarms for the whole 24 hour period in a day and I have two radar charts for the time range 12 AM to 12 PM and 12 PM to 12 AM. I am basically trying to show the number of alarms in the two radar charts and make the radar chart look like a clock. So each category (Time Range) in the radar chart shows the number of alarms in that category (Time Range). It looks like this:

The values in the radar chart are:

So far, it works perfectly. However, I also need to add a slicer for the area so that the customer can select the area and see the number of alarms only for a particular area on the same radar chart as above. Problem is that, not all areas generate alarms in all the time ranges during the day. Some area might only generate a couple of alarms during the day. Beacuse of this, when I add an area slicer, the radar chart shape changes. An example of this is:

The axis of the radar chart changes and it no longer looks like a clock.  Or an even worse example:

Is there a way to add this area slicer without affecting the radar chart categories such that the area which only has two alarms a day, for instance, the radar chart should show the number of alarms for that area in the time range in which it occurs, and show a value of 0 for the other time ranges? My main aim is to preserve the clock like face of the radar chart.

Thank you,

Any help will be greatly appreciated.

[v-yiruan-msft]

Hi @uni_student,

According to my investigation , currently there is no setting or method to fix this category of radar chart. Only the corresponding category and values are displayed on the radar chart when use the slicer to make filter. Maybe you can contact Power BI Custom Visuals Support to submit your requirement.

Best Regards

Rena