Forum Discussion
Need help with creating visual interactions between two tables
Hey guys,
I want to have two graphs: the first graph is based on Table 1 and should reflect the variance in the value by product; for the second graph i need to recalculate the difference between variance and threshold in the table 2 to input as a value and show it by asset category. Two graphs should interact with each other; for example, when I click on the Bike category in graph 2 i should see Products filtered out on graph one. I need help with the formula for the graph 2.
| Table 1 | |||||
| Asset Category | Actual | Budgeted | Variance | Product | |
| Bikes | 50 | 40 | 10 | Bike 1 | |
| Bikes | 60 | 70 | -10 | Bike 2 | |
| Bikes | 20 | 30 | -10 | Bike 3 | |
| Bikes | 170 | 260 | -90 | Bike 4 | |
| Mopeds | 110 | 50 | 60 | Moped 1 | |
| Mopeds | 90 | 50 | 40 | Moped 2 | |
| Table 2 | |||||
| Asset Category | Actual | Budgeted | Variance | Threshold | Material Difference |
| Bikes | 300 | 400 | -100 | 90 | Yes |
| Mopeds | 200 | 100 | 100 | 80 | Yes |
Appreciate any help!
1 Reply
Anonymous , You can create and a common asset table/dimension and use that for analysis
asset = distinct(union(all(Table1[Asset]),all(Table2[Asset])))
