Forum Discussion
Solved
Dynamic Radar Chart using date slicers
Hi I have a main table (called TableExample) with many columns (about 100) and rows ( in thousands) but here are the needed columns I will be working with and a sample data: Date HF30 MI30 ST...
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 gmsamborn
Thanks for your test.pbix! I saw what you did with the relationship so I created a new calendar table and linked the relationship to both the orginal table and the new attibute table. IT WORKED! You are a LEGEND! THANK YOU!!!