Date slicer not working with calculated table

Question

I have a table with events view that has "ReceivedDate" column (ie 3/20/2020 12:00:00 AM), I would like to filter that table so when I use other columns in the table for calculated tables, the data is based on a date slicer using "ReceivedDate".

I am principally interested in using this for a Pareto chart. I have been able to get the Pareto chart to display correctly, however I can not change the date.

Is this possible? I've tried alot of different things, nothing seems to filter based on date from a visual slicer

any hlep would be appreciated

edhans · Answer

We'd need to see your model and what is in your calculated table, but there is no reason a slicer will not filter a calculated table that I am aware of.

amitchandak · Answer

Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example. 
&nbsp;
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 : https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions https://www.archerpoint.com/blog/Posts/creating-date-table-power-bihttps://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184Appreciate your Kudos.Appreciate your Kudos.

anonymous · Answer

These are columns from source table view:

ReceivedTime

AgentName

EventCategory

EventName

EventDescription

RawText

ExtractedDate

I create a column ExtractedDate to get a time/date stamp per day. Maybe this is not needed?

ReceivedTime ex. "3/2/2020 11:07:43 AM", Extracted date "3/2/12:00:00 AM"

ExtractedDate = DATEVALUE('EventData'[ReceivedTime])

for pareto chart:
create table with these 4 columns, event count per event name:

metricNames = DISTINCT('EventData'[EventName])

EventCount = CALCULATE(counta('EventData'[EventName]),FILTER(ALLSELECTED('EventData'), 'EventData'[EventName] = metricNames[EventName]))

EventCountRank = RANKX(ALL(metricNames),metricNames[EventCount])

RunningTotal = CALCULATE(SUM('metricNames'[EventCount]),ALLSELECTED(metricNames),'metricNames'[EventCountRank] <= EARLIER('metricNames'[EventCountRank]))

above is my calculated table (metricNames), returns:

EventName

EventCount

EventCountRank

RunningTotal

Table relationship:

EventData[EventName] many to many metricNames[EventName], perhaps I need to include a date relationship in my calculated table "metricsNames" somehow?

If I create a date slicer on EventData[ExtractedDate] or EventData[ReceivedTime] the metricsNames[EventName] changes, but the other 3 columns never changes.

I would think (maybe wrongly) that if I change the date range, the number of events is reduced, calculated columns change.

If this is not the way to do this, please let me know. I need to have the date slicer vary the events
for those calculated columns.
Thanks for your help

v-deddai1-msft · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Would you please inform us more detailed information( your&nbsp; data(by OneDrive for Business)) if possible? Then we will help you more correctly.&nbsp;Please do mask sensitive data before uploading.&nbsp;Thanks for your understanding and support.&nbsp;Best Regards,Dedmon Dai

anonymous · Answer

I'm not sure if I have access to OneDrive for business, it is where? I do have a OneDrive I can share a file out. I can export data to CSV and mask sensitive data if that is ok.

Forum Discussion

Date slicer not working with calculated table

10 Replies

Related content

Calculation not working when slicers applied

Sync Slicers Not Working Between Button Slicer and Standard Slicer

synchronized slicers not working online dashboard

Calculating Working hours

Slicer doesn't work properly