Forum Discussion
Helper IRadar chart to create default values for comparison operation
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
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.