Forum Discussion

Frequent Visitor

2 years ago

Solved

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 r...

Need Help

parry2k
2 years ago
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.

Filter a slicer value and the data table updates with corresponding value.pbix20 KB

learn4life

Frequent Visitor

2 years ago

MNedix parry2k apologies for the confusion, Belgium 100% should show as well, I've cleaned up the outcome table to make things clear, hope this clarifies.
Desired output

Operator	country	Ownership	Project
Company A	Belgium	33.33%	Project 1
Company A	Belgium	100%	Project 2
Company A	USA	33.33%	Project 5

Forum Discussion

Filter a slicer value and the data table updates with corresponding value

Related content

Filter corresponding columns

App not updating

Sumif of multiple corresponding values

Personal Bookmark Overwriting Updates to Filter Pane

Updating filter via JS results in duplication of filters in filter pane