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

[Anonymous]

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

Location	Sales
Region / District / Street	6523 $

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.

[amitchandak · Accepted solution]

@Anonymous , You have to use bookmarks or convert columns to rows

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

[Anonymous]

Thanks @amitchandak , for me Bookmark worked.