Forum Discussion
Multiple Slicers on One Table
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 - ...
- For this you will need multiple disconnected slicers with measures to harvest the user choices and set defaults if no choice is made. Then use Dax in measures to filter individual measures.
Here is an example using multiple date ranges to overlap two data sets that I helped someone build for a different solution. https://1drv.ms/u/s!AuCIkLeqFmlhhJkIcpsdkWzMMqeBBw
It’s more complex than what you need but demonstrates the principles
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?
For this you will need multiple disconnected slicers with measures to harvest the user choices and set defaults if no choice is made. Then use Dax in measures to filter individual measures.
Here is an example using multiple date ranges to overlap two data sets that I helped someone build for a different solution. https://1drv.ms/u/s!AuCIkLeqFmlhhJkIcpsdkWzMMqeBBw
It’s more complex than what you need but demonstrates the principles
Here is an example using multiple date ranges to overlap two data sets that I helped someone build for a different solution. https://1drv.ms/u/s!AuCIkLeqFmlhhJkIcpsdkWzMMqeBBw
It’s more complex than what you need but demonstrates the principles
Hello, I tried the link that you shared, but receievd an error.
Could you kindly send the link again, please?