Forum Discussion
Filter a slicer value and the data table updates with corresponding value
Power BI Community,
I am currently working on a power bi project and am looking for assistance.
Scenario, let's say a user selects a value from the slicer this should update a data table with related values, for example, below is a sample table with 3 columns (country, operator, ownership) the slicer will be based on operator, so let's say Company A is selected then the data table should display Belgium and USA since it's involved in both countries. In addition, for ownership it should only display the ownership for Company A. Table 2 below shows the expected outcome. Appreciate your help.
| country | Operator | Ownership |
| Belgium | Company A | Company A (33.333%), Company B (33.333%), Company C (33.333%) |
| Belgium | Company A | Company A (100%) |
| China | Company B | Company B (100%) |
| China | Company C | Company C (100%) |
| USA | Company B | Company A (33.333%), Company B (66.333%) |
| Desired result | ||
| Operator | country | Ownership |
| Company A | Belgium | 33.33% |
| Company A | USA | 33.33% |
learn4life see attached, you need to transform the data in PQ. I have added the transformation steps to shape the data. You can use that and improve it as per your requirements.
7 Replies
- parry2k
Super User
learn4life see attached, you need to transform the data in PQ. I have added the transformation steps to shape the data. You can use that and improve it as per your requirements.
parry2k thanks this will get the job done.
- MNedix
Solution Sage
How is the percentage of Ownership calculated? Is this something coming from the source file as a percentage or txt?
- parry2k
learn4life why the company A Belgium 100% is not showing?
It's currently as text. Thanks
- parry2k
learn4life always tag the person to whom you are replying. Just basics of communicating on the forum. Your last reply is not clear, it is the answer for which question?
