Reply
Milan6687
Helper II
Helper II

Change column in table view based on slicer

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:

CompanyTotal SalesTotal Revenue
ABC100500000

 

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:

BusinessTotal SalesTotal Revenue
htd5030000

 

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.

 

 

3 REPLIES 3
avatar user
Anonymous
Not applicable

@Milan6687  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
Super User
Super User

@Milan6687 , 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/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
kumar27
Advocate V
Advocate V

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)