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.
I have a very large table that I would like to apply some slicers to. Because the table is so large, I'd like to have multiple slicers acting on it. Below is an example of my data:
Vehicle ID - Miles - Num of Vehicles
1 - 10000 - 20
1 - 12000 - 20
1 - 10000 - 22
2 - 10000 - 20
2 - 12000 - 20
2 - 10000 - 22
I would like to have slicers for each column/vehicle ID combo. For example, I need the user to select for Vehicle ID 1, how many miles and the number of vehicles. For vehicle ID 2, I need them to select the miles and number of vehicles, etc.
Thanks!
Solved! Go to Solution.
so build them 🙂 I'd recommend setting up some Lookup Tables to linked to your data and filter on those. Will also function as bridge tables when you start using multiple source (FACT) tables.
Few ways to do do this.
in Power Query
In DAXX
Vehicle IDs = VALUES(table[Vehicle ID])
I sort of follow... but how would it work if for Vehicle ID 1 I wanted to select 10,000 miles and for Vehicle ID 2 I wanted to select 12,000 miles?
Hello, I tried the link that you shared, but receievd an error.
Could you kindly send the link again, please?
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |