Forum Discussion
Dynamic Radar Chart using date slicers
Hi whgenie
By adding a date column (not datetime) to the source table, I can add a 1:* relationship between the date table and the source table. This way the source table visuals would react to the slicer like the unpivoted table visuals.
(The duplicate table has to be a duplicate of the source table - not a reference.)
Dynamic Radar Chart - test.pbix
Let me know if you have any questions.
Hi lbendlin
gmsamborn had private messaged and trying to help me. I've downloaded the .pbix file which has your codes and had a look. Some issues:
1. The radar values are wrong. It sums everything up so if there are -1 values, it actually minus off the totals. I want to count 1 only and ignore 0 and -1.
2. The problem with unpivoting is that it will affect my original table which has many other data that are being used. So what I did was:
- I duplicated my orginal table to a new table as a reference to the orginal table
- Now using the new table, I removed all other columns except the Date, HF30, MI30, ST30, STR30, and BL30.
- Then unpivot as Ibendin did = Table.UnpivotOtherColumns(#"Removed Other Columns", {"DOP"}, "Attribute", "Value")
- Then to replaced all -1 values with 0 (now the table only has 0s and 1s)
- Created Radar chart, dragged and dropped Attribute into Category and Sum of Value into Y Axis
The radar chart output the entire table's sum of the individual Attributes (all date range of the entire table from 2013 to 2023). Now, when I use my slicer to show only July 2023, the radar chart still does not update and still shows entire sum of values of 2013 - 2023.
When I click on the radar chart's filter, it says correctly that the year has been applied when I changed the slicer date but the values remain the same:
How do I make the date slicer (which is sourced from my original table) work on my radar chart?
Did you follow my advice and unpivot the data? Can you post a sample pbix?
Yes I did (see above my steps) but I unpivoted on a duplicate table not orignal table. I'll remove some of sensitive data and post a sample pbix file in private message to you soon. Allow me some time. Thank you in advance for your help!
Your unpivoted table seems to work fine.
Hi
You seemed to have removed my other charts and updated the date slicer to the date on the unpivoted table. That works however, that means all my other charts will not be updated with the date slicer. That is not what I want.
I need BOTH other charts AND this radar chart to be dynamic whenever new date slicer is applied. How do I do that? Thank you!