Radar chart to create default values for comparison operation

[anshenterprice]

Hi Team,
Source table

Data Set 1
Category	Date	Red	Green	Yellow	White
ABC	8/15/2022	5	2.5	3.5	1.5
DEF	8/15/2022	4.4	5.2	7.4	2.5
GEF	8/15/2022	5.1	5.8	4.4	4.4
HIJ	8/15/2022	5.8	6.4	5.1	5.1
Data Set 2
Category	Date	Red	Green	Yellow	White
XYZ	8/15/2022	3	4	6	2
PQR	8/15/2022	3.7	4.6	1.8	4.7

i want to create a Radar chart below are the filters and chart  
Radar chart- Category-Category field Values -Red Green Yellow White
Filter- Category column
Filter - Date Column

but my condition is i always want to see dataset2 (XYZ and PQR) in radar char whenever i filtered any category from the category filter because i want compare my first datas

[Anonymous · Accepted solution]

Hi @anshenterprice ,

I suggest you to create an unrelated dim category table for slicer and then create a measure to filter your Radar chart.

My Sample:

Measure:

Measure = 
IF(
ISFILTERED('Dim Category'[Category]),
IF(MAX('Source table'[Category]) in VALUES('Dim Category'[Category]) || MAX('Source table'[Data Set]) = "Data Set 2",1,0),
1)

Add this measure into visual level filter and set it to show items when value = 1. Result is as below.

Best Regards,
Rico Zhou

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