Filter whole page with conditions from different tables

[kitti]

Hi experts,

I want to do filtering by conditions from different tables to the entire page of a power bi dashboard.

For example: I want to filter out Product A (table products) and Branch CT1 (table areas).

How do I do that? Please help.

Thanks

KL

[amitchandak]

@kitti , the filter can be applied on the table(dimensions) or the joined tables(Facts) . Depending on the relationship a "Slicer" or page level filters can be used

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[kitti]

Hi @amitchandak ,

Thank you for your message.

I have a Product table and an Area table.

Product table:

product_id, product_name, ingredient, price

and Area table:

branch_id, branch_name, sales_zone, product_id

I want to do this filtering --> If product_name = 'A' then branch_name != 'CT1'    (but for other products, will include branch_name CT1)

for all charts on the entire page.

Thanks,

KL

[amitchandak]

@kitti , if both tables have an active join on product id. It should work.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[kitti]

Hi @amitchandak ,

Sorry I cannot share the data. I tried using the filters pane with advanced filtering but it doesnt work. Can you please give some examples? Very similar to if-else condition I suppose.

Thanks,

KL