I have two tables, “User Database” & “Job 001 Applications”, both have varying data points, but an applicants unique ID will appear on both tabs, to link user data to a users application and that specific data.
In theory, user data remains the same, however their application data may very for each application, ie Job 001 & Job 002.
I need to display both tables data in a dash board, in 3 views, user data, user detailed view, and the application specific data.
When I activate the “Interactive Mode” for the dash board, obviously the User Data and detailed user data, are correlated and so both change in unison, but the application data does not change, to newly selected user, thus not showing the correct application data for the user that is selected (it has to be done manually). Any solutions around this?
Any other ideas, are always welcome. Application
Application data kept separate from user database, but is linked to a user.
Solved! Go to Solution.
Hi @Tuskan,
Thank you for more details. These certainly help. If I have understood your requirement correctly, you could create the dashboards in any of the following two approaches.
IN([User ID], SELECT(Applicants[User ID], [Status]=“Offer Made” ) ),
Please have 2 more similar slices for other two statuses and similarly 3 dashboards with the first with based on each of the 3 slices and next two views based on detail views - identical for all three dashboards.
In the slice filter of the Database table expression you could have an expression something like
IN([User ID], SELECT(Applicants[User ID], [Status]=ANY(OfferStatus[Offer Status]) ) ),
Please include the three views as earlier and a fourth detail view based on OfferStatus table that allows the user to select the types of offers through enum button.
The OfferStatus table can have only one row, if only one user uses the app or you will need to include more rows in the OfferStatus table, one per each user, to retain selection of each user if many users will the app simultaneously.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |