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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

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,248
Messages
5,413,297
Members
403,472
Latest member
ArtisticOwl

This Week's Hot Topics

Top