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've got following problem:
I have a table that looks a bit like this:
Product ID | Category1 | Category2 | Revenue |
1 | Dresses | 100 | |
2 | Dresses | 200 | |
3 | Jackets | Sport | 300 |
4 | Sport | 400 | |
5 | Shoes | 500 |
Now, I have a Slicer through which I only visualise the Revenue for Products from one Category. Now I basically want to find a way to select "Sport" and visualise Product 3 and 4.
Thankful for every workaround idea!
Leon
Solved! Go to Solution.
Hi @Anonymous
Go to Edit queries,
create a duplicate table Table2,
In Table2, unpivot columns "category 1" and ""category 2",
filter "Value" column to remove empty,
close&&apply.
Create relationship between Table1 and Table2 on "Product ID"
Add "value" from Table2 in a slicer.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
Hi @Anonymous
Go to Edit queries,
create a duplicate table Table2,
In Table2, unpivot columns "category 1" and ""category 2",
filter "Value" column to remove empty,
close&&apply.
Create relationship between Table1 and Table2 on "Product ID"
Add "value" from Table2 in a slicer.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So that if I visualised the table, it would only be
Product ID | Category1 | Category2 | Revenue |
3 | Jackets | Sport | 300 |
4 | Sport | 400 |
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |