Dynamic slicer

Nando1988

New Member
Joined
Aug 21, 2019
Messages
9
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.
 

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,189
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,084,984
Messages
5,381,022
Members
401,712
Latest member
Aubin

Some videos you may like

This Week's Hot Topics

Top