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.
Hello I want to add a conditional column based off the information below. The conditional column would be for the stores in column B. So for instance if Column B = Orange then Target. My issue is that I want column B to be a slicer but I have apples in 2 tables ( Walmart and Wholefoods).
How can I create it so that if Column A = Apple than Walmart
and also show that if column A = Apple than Wholefoods
I need it to show once I select wholefoods in the Slicer I see apple and once I select Walmart in the slicer I also see apple without combining the 2 names.
Solved! Go to Solution.
I'm not quite sure I understand. From what I see you need to unpivot your 'Store' table so it looks like:
Then you can use [Value] as your slicer which then filters your [Attribute]
Proud to be a Super User!
Hi @Anonymous
You need to add the stores to Column B and then use the field Column B as a slicer to filter fruits .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Please show the expected result.
Hi @Anonymous
You need to add the stores to Column B and then use the field Column B as a slicer to filter fruits .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm not quite sure I understand. From what I see you need to unpivot your 'Store' table so it looks like:
Then you can use [Value] as your slicer which then filters your [Attribute]
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |