Forum Discussion

lnforman's avatar
lnforman
Frequent Visitor
6 years ago
Solved

How to structure or connect data to allow for click down visual?

Hello, 

I am hoping to get a better understanding of how to structure and connect two data tables in order to allow for a click down visual instead of two separate visuals. Below I have shown my current graph how I would like to change it. Below that I've shown how my data is structured.

 

This is my current graph showing progress completed on all projects by quarter and week. I would like to add a slicer so that I can select a specific project and see just for that one project how much progress was made by quarter and week.

 

 

My data set structures...

 

In one data set I have a list of projects worked on by quarter and the progress (as a percent) that was made each week of that quarter. The progress for each project is represented in two ways: 1) percent progress made JUST that week and 2) percent progress made to date for that quarter. Example...

 

QuarterWeekSystemPercent Progress For Specific WeekOverall Progress for Quarter
Q1Week 1Oracle0.5310.531
Q1Week 1SAP0.6160.616
Q1Week 1JDA0.6760.676
Q1Week 2Oracle0.1990.73
Q1Week 2SAP0.0990.715
Q1Week 2JDA0.0640.74

 

I then have a separate table that shows the same progress percentages, but taking into consideration all projects for a week.

 

QuarterWeekPercent completed for specific weekPercent Complete overall for quarter
Q1Week 10.530.53
Q1Week 20.200.73
Q1Week 30.230.96
Q1Week 40.020.99
Q2Week 10.270.27
Q2Week 20.560.83
Q2Week 30.070.90
Q3Week 10.320.32
Q3Week 20.620.94
Q3Week 30.050.98
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi lnforman ,

     

    You may create calculated column in the second table 'Table2' to get the related Project, assuming the "Project" as you said is referred to the Table1[System] and there is a relationship between Table1 and Table2 .

     

    System_matched= RELATED(Table1 [System])

     

    Then you may put the Table2[System_matched] into Legend box of chart.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi lnforman ,

     

    You may create calculated column in the second table 'Table2' to get the related Project, assuming the "Project" as you said is referred to the Table1[System] and there is a relationship between Table1 and Table2 .

     

    System_matched= RELATED(Table1 [System])

     

    Then you may put the Table2[System_matched] into Legend box of chart.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.