Date slicer not working with calculated table

[knasveschuk]

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

[v-deddai1-msft]

Hi @knasveschuk ,

Would you please inform us more detailed information( your  data(by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[knasveschuk]

I have a pbix uploaded to powerbi .com, how do I share this? It asks for email, when sharing.

[v-deddai1-msft]

Hi @knasveschuk ，

Please refer to https://www.itprotoday.com/office-365/how-share-file-or-folder-onedrive-business-office-365 to share files.

Best Regards,

Dedmon Dai

[knasveschuk]

Hi @v-deddai1-msft ,

I have a 60day Power Bi Pro license, I think I can now share my data file with you via OneDrive for Business

[knasveschuk]

Hi All,

I think what I need to create is a dynamic table for what I am trying to accomplish and why date slicer does not work. If anyone has any other ideas.
from this post:

https://community.powerbi.com/t5/Desktop/Create-dynamic-DAX-table-filtered-by-slicer-from-another-ta...

This is what I need to do:

-User moves a visual slicer based on date. Number of evaluated, rows changes

-Calculated table changes (for Pareto chart), is this correct? possible?

any help would be appreciated

[knasveschuk]

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.

[knasveschuk]

I do not have Power Bi service, I am a Power Bi Desktop user, standalone at the moment. There is no option for OneDrive Business.

[amitchandak]

@knasveschuk ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

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-bi
https://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-Y...


Appreciate your Kudos.
Appreciate your Kudos.

[knasveschuk]

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

[edhans]

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.