Use Data Type with a slicer - How to connect them?
Discover the trick to connect Data Type with a slicer. This trick will transform your dashboard to another level of analyse.
All the explanations are detailed in this article
https://www.excel-exercise.com/connec...
00:00 Introduction
00:12 What is Data Type
01:27 Create a Table with your field and an ID
04:02 Insert the slicer of the column of the Table
04:27 Function SUBTOTAL
05:36 Embedded the result in the function XLOOKUP
06:26 Creation of the formula with FIELDVALUE
08:34 Correct the N/A error if there is no selection
09:22 Correct the SPILL Error when Data Type return more than one result
10:15 Add new field for the slicer