Slicer for locale

[xRTP]

Hello, 

I've been doing a project and new to power BI. How to create a slicers that will show tables base on selected slicer. I want to create a slicer for locale US & CA, then if i click the US in slicer, the table US Mailbox will show (same with CA). I really need your help. Thanks!

[Samarth_18 · Accepted solution]

Hi @xRTP ,

I would suggest you to create a two seperate pages for CA and US then use page navigator for navigation. After that hide one page so that user will not able to see it in services and it looks like everything happen on same page.

You refer a attached file.

BR,

Samarth

[xRTP]

Thank you very much! I guess this is much better!