Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I'm trying to return certain values in a column based on a selected business unit.
The business units have several products, but its only certain products and their weight that I'm interested of.
Firstly, I have created a measure for each unit and their products and weights.
If there is a relationship between BU and Products (e.g. they are in the same table or there is a bi-directional relationship between their tables), check to see that visual interactions is enabled between the two slicers.
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...
Or you can use a BU > Product heirarchy and just hiding the specific BU / products that you aren't interested in.
Thank you.
There is a relationship.
however there's a lot of BU and they all have specific products that I'm interested in. This solution is dependent on me editing, I'm looking for a more scalable solution.
I want the user to be able to change BU and only get the products specified for that specific BU in another slicer.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |