Radar Chart Timeline Filter

[FraserGreen]

Hi,

I am looking to create a radar chart that can include a filter (slider) for the month. I can easily show one month's data on the radar chart and create buttons using bookmarks for the offers but ideally, we want a slider filter to enable us to visualize the change and make it scalable (having buttons and bookmarks doesn't work if there are more months added to the dataset).

Thanks in advance.

The data looks like this:

cust id	project id	date	ans1	ans2	ans3	ans4	ans5	ans6	ans7	ans8	ans9	ans10
1	1	Apr-20	3	4	2	2	5	3	2	2	3	3
1	1	Jun-20	4	7	3	5	8	4	3	3	4	5
1	1	Dec-20	3	8	7	4	4	4	4	6	5	6
1	1	Jul-21	7	4	6	2	3	8	5	7	8	2
1	1	Aug-21	8	2	9	1	1	2	7	8	9	3
1	1	Sep-21	6	9	8	7	5	3	6	9	8	8
1	1	Oct-21	2	7	7	4	4	4	9	5	6	9

[FraserGreen]

Hi @lbendlin 

Thanks so much for taking the time to create the pbix file - I did have this as an option but if there is a new date added to the dataset then I'd need to re-do the dashboard every time. Ideally, I want it as a slider (filter) so if a new data is added (row) then it automatically updates the filter. Do you know if that is achievable? 

[lbendlin]

You don't need to "re-do the dashboard" (whatever that means).  The date slicer will automatically be populated with the new dates.  You may run out of screen real estate with the chosen slicer UI so you may have to go for a date range instead etc.

[lbendlin]

Like this?

see attached