- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-27-2024 09:04 AM | |||
06-27-2023 09:54 AM | |||
Anonymous
| 04-02-2024 06:27 AM | ||
03-26-2024 03:14 AM | |||
03-27-2024 10:23 PM |