Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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 .
@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/
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |