Multiple filers

[Anonymous]

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?

[Anonymous]

Thanks a lot. But then I can not display nthe number of profiles by Internal owner previosu vs. current in a table, or can I ....? 

[amitchandak]

@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