Display or show data in table for only on selected date.

[nrsyuhada]

Hi, 
I want to show or display data in table view if the user select the single date. But currently the data show on or after the selected date. I want to show only on that date. Is there any solution or dax formula? Here is the reference. 

when user select the date, I want it to show only 34 article number filtered distinct value but right now it show all the article number that are not in the selected date. 

I have tried this dax but it show one data. 

Table =

var selectedDate = MIN('AllData'[Test_Date_Time])

return

CALCULATETABLE(

'AllData',

FILTER('AllData', 'AllData'[Test_Date_Time]=MAX('AllData'[Test_Date_Time]))

)

Thank you. 

[VahidDM]

Hi @nrsyuhada 

You can't get data from slicer and create a table based on that, because of that it shows one line item.

Can you share a sample of your data and the desired output in a text format?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[nrsyuhada]

Hi @VahidDM 

Thank you for your respond, This is my sample of data: 

Test_Date_Time	Article_no	Order_No
11/11/2021 13:35	1100002	335336
11/11/2021 13:39	1100002	335336
11/11/2021 13:42	1100002	335336
09/11/2021 22:38	1101002	328570
09/11/2021 22:42	1101002	328570
09/11/2021 22:45	1101002	328570
09/11/2021 22:47	1101002	328570
09/11/2021 23:04	1101002	328570
09/11/2021 23:06	1101002	328570
09/11/2021 23:10	1101002	328570
09/11/2021 23:13	1101002	328570
09/11/2021 23:15	1101002	328570
09/11/2021 22:57	1101002	335336
01/11/2021 11:19	1400001	333288
01/11/2021 11:25	1400001	333288
12/11/2021 10:23	1400001	334980
12/11/2021 10:28	1400001	334980
12/11/2021 10:30	1400001	334980
12/11/2021 10:33	1400001	334980
12/11/2021 10:37	1400001	334980
12/11/2021 10:41	1400001	334980
12/11/2021 10:44	1400001	334980
12/11/2021 10:48	1400001	334980
12/11/2021 10:54	1400001	334980
12/11/2021 10:56	1400001	334980
12/11/2021 11:04	1400001	334980
12/11/2021 11:15	1400001	334980
12/11/2021 11:20	1400001	334980
12/11/2021 11:26	1400001	334980
12/11/2021 11:29	1400001	334980
12/11/2021 11:32	1400001	334980
12/11/2021 11:34	1400001	334980
12/11/2021 11:38	1400001	334980
12/11/2021 11:41	1400001	334980
12/11/2021 11:43	1400001	334980
12/11/2021 12:15	1400001	334980
12/11/2021 12:17	1400001	334980
12/11/2021 12:23	1400001	334980
12/11/2021 12:25	1400001	334980
12/11/2021 12:28	1400001	334980
12/11/2021 12:29	1400001	334980
12/11/2021 12:38	1400001	334980
12/11/2021 12:43	1400001	334980
12/11/2021 12:46	1400001	334980
12/11/2021 12:48	1400001	334980
12/11/2021 12:50	1400001	334980
12/11/2021 12:55	1400001	334980
12/11/2021 12:57	1400001	334980
12/11/2021 13:00	1400001	334980
12/11/2021 13:06	1400001	334980
12/11/2021 14:39	1400001	334980
12/11/2021 14:41	1400001	334980
12/11/2021 14:45	1400001	334980
12/11/2021 14:54	1400001	334980
12/11/2021 14:57	1400001	334980
12/11/2021 14:59	1400001	334980
12/11/2021 15:04	1400001	334980
12/11/2021 15:12	1400001	334980
12/11/2021 16:54	1400001	334980
12/11/2021 17:01	1400001	334980
12/11/2021 17:06	1400001	334980
12/11/2021 17:09	1400001	334980
12/11/2021 17:11	1400001	334980
12/11/2021 17:14	1400001	334980
12/11/2021 17:16	1400001	334980
12/11/2021 17:23	1400001	334980
12/11/2021 17:31	1400001	334980
12/11/2021 17:44	1400001	334980
12/11/2021 17:49	1400001	334980
12/11/2021 17:57	1400001	334980
12/11/2021 18:05	1400001	334980
12/11/2021 20:08	1400001	334980
12/11/2021 20:11	1400001	334980
12/11/2021 20:15	1400001	334980
12/11/2021 20:19	1400001	334980
12/11/2021 20:23	1400001	334980
12/11/2021 20:25	1400001	334980
12/11/2021 20:28	1400001	334980
12/11/2021 20:43	1400001	334980
12/11/2021 20:51	1400001	334980
12/11/2021 20:54	1400001	334980
12/11/2021 20:56	1400001	334980
12/11/2021 21:12	1400001	334980
12/11/2021 21:15	1400001	334980
12/11/2021 21:19	1400001	334980

My desired output is to show data for  date only on 09/11/2021.

In Data View I can filter the Test_Date_Time equal to the date.

But in the Report View it show data on 09/11 and after 09/11. Is there any solution for this, sir? 

Thank you. 

[nrsyuhada · Accepted solution]

Hi, 

I find the solution. But it is not in calendar or date picker style. 
I use date hierarchy and split each into one slicer. 

Here is the design. 

but if anyone has solution for the previous question which is when user click the date in calendar it will show the data. can share it.

Thank you.  

[v-easonf-msft]

Hi, @nrsyuhada 

How did you create the slicer in your first screenshot?

It seems that your slicer is constructed based on a range slicer, right?

、

"Before", "after", and "between" are not applicable to you, they are more applicable to the selection of date range.

Best Regards,
Community Support Team _ Eason

[nrsyuhada]

hi @v-easonf-msft 

from the first screenshot, yes i used the slicer and hide the after selection. 

I think because of that my data date show from the selection date on and after the selection date. 

Thank you.