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.
I showed you how you can refactor your source. I won't be able to help you if you insist on fixing your original setup.
Thank you for showing me. Your coding does solve a small part but as a Data Analyst, if having one working visual but broke all the rest of visuals on the Dashboard (or all visual works except one), then this is not a good dashboard I want to publish.
I'll use your code but then I will figure out how to make the date slicers work for all visuals from different tables.
Unless someone else have a solution for this, I'd be GREATLY indebted! Thank you so much for your help so far!
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.