Forum Discussion

mtp03's avatar
mtp03
Frequent Visitor
3 years ago

Multiple tables

I have 2 tables that I want to incorporate into 1 combo bar/line graph that can be maniplulated using slicers for date ranges and particular User IDs. My intent is to have bars showing counts for eac...
Need Help
Tutorial Requests
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi mtp03 

Just create a bridge table containg all the unique user Id's and link it 1 to n with both tables. Then you can use to slice by in you visual. You can create this table using DAX but to avoid any chance of circular dependancy I preffer to have it created in power query or from source.

mtp03's avatar
mtp03
Frequent Visitor
3 years ago

I did this but the problem is the line for goals is just the sum of all for the month (so the bars show the actual entries person but the line is just straight across). I want the line to show the value per User ID. How do I make it reflect that?

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    mtp03 

    Can you please share a screenshot for better understanding?

    • mtp03's avatar
      mtp03
      Frequent Visitor
      3 years ago

      This is what it looks like filtered for 1 month. Se ehow the goal line is a sum of everone's goal instead of going up and down to show each person's specific goal?

       

      I want it to look like this, but keep in mind each month the goals change for each person. I tried doing a table for a single month's goals but then there is no historical data captured: