Forum Discussion
Multiple filers
I have a complex dashboard but a simple question.
Let’s say I have two Excels as source and three columns each: Profile, Internal owner and Active (Active/Inactive).
The two Excels represent a historic view, one previous, the other one current.
So the status may have changed.
The relationship is set to one:one (both) for Profile; also for the rest of the dashboard.
My trouble is this: I do not manage to get a table view that displays active profiles previously and currently based on a single filter or slicer for ‘active’ because the view changes depending on whether I select the Status field (active/inactive) from the previous or the current Excel source.
It should show 234 (previous) vs 102 (current).
Does anybody have any idea?
2 Replies
Anonymous , better to join these two tables and common dimensions Active , internal owner and profile and then take current and prior measure and compare them with each other
