Forum Discussion
How to filter data using two slicers
Hi, I have three tables: `origin`, `destination`, and `all_local` table which has the geo data points for all the the (unique) locations. Based on the user's selection, I'd like to visualize the...
HI Rza_o,
Did these tables and filter link to the same geo field? If that is the case, current power bi will use AND logic to link different filter effect. So if you select item on different filters, they will be filtering records which match all the filter items.
If these filter conditions are contradictory, it will affect the visualization and no data displayed because not existed records match all conditions at the same time.
For this scenario, you may need to break the relationship and directly extract these selections to use Dax expression to calculations.
Regards,
Xiaoxin Sheng