How to capture the value of a data selected from a Slicer field in Excel formula or Excel Cell?

Question

I have created a slicer as presented below, and one I open its sittings, I have noticed the defined name to use in formula.

I tried to capture the value of this Named field and use the "Indirect" formula as below to display its value. But I got "#REF" as a in the value in the CELL instead!!!

How can I make the CELL displays the date selected which in this example 06/27/2022 01:58:28 PM?

Answer 1

Hi ThamerTarabzouni,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I have carefully gone through your question and please allow me to test from my side to see if we can achieve your requirement.

Once we get results that meet your requirement, we will post back with the results.

At the same time, I would also like to invite expert MVPs and other community members to share their rich ideas concerning this question to see if we can achieve your requirement together.

Thank you for your kind understanding , cooperation and patience.

Sincerely,

Edwine | Microsoft Community Moderator

Answer 2

Hi,

From the image, i can guess that you have created this slicer from the Data Model. In any cell, enter this formula in cell E10

=CUBESET("ThisWorkbookDataModel",Slicer_PI_ID1_UpdateTime1,"Date")

In cell E11, enter this formula

=CUBERANKEDMEMBER("ThisWorkbookDataModel",E10,1)

Hope this helps.

Answer 3

Greetings Ashish,

Thank you. But can you review your statements. I'm not getting the desired result.

I just need to reflect in a CELL, the date value selected by the slicer. From what I have read about the CUBESET function, it retains a set of values.

Answer 4

Try the formula.

Answer 5

Hi,

I inserted both formulas in E10, and E11. Yet, It didn't work. It resulted in # N/A as you can see.

I will explore another approach. Thanks.