Change column in table view based on slicer

[Anonymous]

Hi,

I have two tables one Level and other matrix.

Level

Comapny  Organization Business Team SubTeam

ABC            xyz                htd          team1   subteam1

.

.

Matrix

Total sales     Total Revenue

100                500000

.

.

I created Table view like below:

Company	Total Sales	Total Revenue
ABC	100	500000

I have slicer(Comapny  Organization Business Team SubTeam)--created using insert data.

Now based on above slicer slection first cloumn should change. Suppose user slect Business from slicer table should be:

Business	Total Sales	Total Revenue
htd	50	30000

Unpivot option is not avaliable as Level table is created using DAX.

I tried to create measure :SWITCH(SELECTEDVALUE(SELECTEDSLICER,"Company",Distinct(Level[Company]),

"Organization",Distinct(Level[Organizton]), and so on. But some levels have more than one distinct values so its throwing error.

Is there any other way we can achive this.

Thanks in advance.

[Anonymous]

@Anonymous  Hey Milan,
you have to create a refernce table from original table then 
you can create a table in power query mode as well .then you can unpiovt it 

thank you 

try this and let me know .

[amitchandak]

@Anonymous , Are you trying to change axis/ group by /row of visual . Then bookmark is on option

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

other are 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/

[kumar27]

so, at the model side are the two tables connected? 

If they are connected properly, then a metric like - SUM(sales) only will be required and woud filter by the dimemsions.