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.
Hey there,
I want to use a filter to filter the options of another filter. I will be very clear with multiple pictures to show what I mean exactly.
Let's say I have the following dataset (but in reality I have about 100 columns):
ID, AttributeColor, AttributeSize, AttributeType, AttributeRating 1, B, X, AA, 2 2, R, XL, AA, 4 3, G, M, AB, 3 4, B, X, BB, 4 5, B, X, AB, 5 6, B, XL, BB, 3
And what I want is, let's say, filter my dataset on certain values of AttributeSize and AttributeType.
I can create a slicer for AttributeSize and AttributeType, not a problem at all.
However, I want to be able to change the filter in the front-end to be changed to AttributeColor and AttributeRating.
So basically: Filter 1 to select the field I want to filter on, Filter 2 shows the values of the selected field to be filtered on.
What I tried so far:
- Link the same table, but then an unpivoted version of the table.
- Edit relationships. (See pictures below to become very specific)
In case you need a testfile:
https://1drv.ms/u/s!ApYezvnm5pOshWQW4TGubgDqON7Y
The only thing I can think of right now is create 100 tables for 100 columns to make the right selections. However sometimes the table provided has 91 columns, sometimes it has 97, sometimes 41, and sometimes even the names of the fields change. It depends on the organisatie whether they call something 'AttributeSize' or 'Attribute_Size' or 'SizeAttribute', etc.
I am really stuck, I hope someone can think with me here.
Also, if you need anything more, ask me right away!
Kind regards,
Igor
Solved! Go to Solution.
Hey there,
Since I want to select among 90-110 filters in the front-end, but only have a max of 4 filters, I decided to copy the Unpivot table 4 times.
Per Unpivoted table I create 1 slicer based on Attribute and 1 slicer based on Value next to it. Repeat this process 4 times, et voila problem solved.
Kind regards,
Igor
Hi @Anonymous
It seems you may create the slicer table with DISTINCT Function as below. Then set the realtionships to filter the table.
Regards,
Cherie
Hey Cherie, thanks for the suggestion.
However I deal with 100 columns (depends actually, sometimes 90, sometimes 110). So I have to create 110 slicers manually to do this. And still, you already have to choose the slicers you want beforehand instead of users being able to choose them in the front-end.
I want to have 2 filters next to eachother, the first to select the field to filter on, the second to select a value within the selected field. For this you need to have the table unpivoted, that's step 1, but for now I'm lost
Hey there,
Since I want to select among 90-110 filters in the front-end, but only have a max of 4 filters, I decided to copy the Unpivot table 4 times.
Per Unpivoted table I create 1 slicer based on Attribute and 1 slicer based on Value next to it. Repeat this process 4 times, et voila problem solved.
Kind regards,
Igor
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 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |