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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,201
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.
 

Forum statistics

Threads
1,089,672
Messages
5,409,642
Members
403,274
Latest member
Lewis1995

This Week's Hot Topics

Top