How can I make one Dimension column values changing based on the selection in slicer ?

Hello Experts,

I have one requirement as below:

I have a fact table with columns : Region, District, Street, Sales

I want to show data in a Table visual along with a Slicer in Power BI as Below:

Slicer : Location

•    Region
•    District
•    Street

So basically if we select Region from the slicer then the table visual should show only Region values in Location column and the corrosponding aggregarted Sales , likewise for District and Street.

We have to select one attribute at a time from slicer i.e. there is no ultiple selection also.

Thank you in Advance for any help.