Need date slicer to work on summary table/graph as well as the detail level data

[nkress]

Hi, I have a detail file on top below that is connected to the date slicer.  What I need to do is make a table (or just a graph) off of the Summary data found in the bottom right.  This is from a Snowflake Database.

I need to make a graph from the ORD_REVTYPE1 and AUTOMATED_SUCCESS from the summary level table/graph.  So in other words I need the summary table/graph to be connected to the date slicer.  Right now, only the detail level file is conected to the slicer.  At the moment I am pulling these tables from 2 views I created.  The first gathers the detail level data, the second groups, counts, and does a calculation.  I am guessing I would need to make a stored procedure and somehow connect it to the slicer.

In the end I will only be showing the Graph and Slicer which I am guessing will need to be connected to the Stored Procedure.

[v-chenwuz-msft]

Hi @nkress ,

Is that the the date slicer dose not work with the summarize table? Enable the interaction between this graph and slicer.

Change how visuals interact in a report - Power BI | Microsoft Docs

Or Activate the relationship between your tables from date table to the fact table.

Or please share the screenshot of the model view of your pbix, if this does not work.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@nkress , if those are two tables in the model. You can use a common date table joined to required date in each table

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.