Forum Discussion
Specify outcome based on slicer selection
Hi,
Please bear with me while I try to explain the issue as best as possible!
I have three levels of filters. Slicers are made in this order 1. Country 2. Investment target 3. Description.
What happens: When I select Country A, all the corresponsding information appears (all other Description rows of Country A)
What I'm seeking: When I select Country A, I want a specific description to appear (which is applicable to all other investments), but it is being duplicated.
So I just tell powerbi, if I select country A, show me description X, and when I select the Investment Target, show me description X + Y. Intstead of selecting Country A and getting description X and Y (while only X is relevant).
I hope this made sense to you. Appreciate your help!!
4 Replies
- amitchandak
Super User
Anonymous , Based on the description, I think you want to control the values of two unrelated slicers. For that you have use measure from fact and check is nonblank
refer steps :
- amitchandak
Anonymous Can you share some kind screenshot or expected output
- v-diye-msft
Community Support
Hi Anonymous
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
