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.

gmsamborn's avatar
gmsamborn
Super User
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.

whgenie's avatar
whgenie
Regular Visitor
2 years ago

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!!!

  • gmsamborn's avatar
    gmsamborn
    Super User
    2 years ago

    Hi whgenie 

    You're welcome.  I'm glad it worked.