I want to lunch a query which result would fill a table displayed, after i select a data

[cristianj]

So i want to display a date slicer, and after i select a date, it will display a simple table, based on the selected date, but i don;t know to to run the query after i select data.

Thank you

[Anonymous · Accepted solution]

Hi @cristianj 

Are you trying to select a date in a slicer and then turn that slicer into a table based on that date? If I understand correctly, I'm afraid that requirement is not achievable.

If this is acceptable to you, you can have the table visualization displayed based on the date selected in the slicer, like the following:

My sample:

Slicer table:

Create a measure as follows:

Measure = IF(MAX([Date]) >= MIN(Slicer[Date]) && MAX([Date]) <= MAX(Slicer[Date]), 1, 0)

Put the measure into the visual-level filters, set up show items when the value is 1.

Output:

If I've misunderstood you, could you please provide some sample data and the expected results based on the sample data so that I can help you better? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Please remove any sensitive data in advance.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.