Forum Discussion

whgenie's avatar
whgenie
Regular Visitor
2 years ago
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...
Need Help
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    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.

lbendlin's avatar
lbendlin
Super User
2 years ago

Did you follow my advice and unpivot the data?  Can you post a sample pbix?

whgenie's avatar
whgenie
Regular Visitor
2 years ago

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!

    • whgenie's avatar
      whgenie
      Regular Visitor
      2 years ago

      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!

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        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.