Dynamic slicer

Nando1988

New Member
Joined
Aug 21, 2019
Messages
12
I wish to create a measure, so I can dynamically populate a slicer, but the slicers don't accept a measure as input, so I don't know what to do.
Any help will be greatly appreciated.
Thanks.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,202
You can’t add measures to slicers. If you are using power pivot for excel, that is the end of the story. If you are using PBI, you can add a measure as a filter on a slicer in the filter bar on the right, but that may or may not do what you want.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,249
Messages
5,413,301
Members
403,474
Latest member
Rampestamper

This Week's Hot Topics

Top