Forum Discussion
Radar Chart Timeline Filter
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 |
3 Replies
Like this?
see attached
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?
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.
