Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
knasveschuk
Helper I
Helper I

Date slicer not working with calculated table

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

 

 

 

10 REPLIES 10
v-deddai1-msft
Community Support
Community Support

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

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

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

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

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

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.

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
Super User
Super User

@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.

These are columns from source table view:

 

ReceivedTimeAgentNameEventCategoryEventNameEventDescriptionRawTextExtractedDate
 
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:
EventNameEventCountEventCountRankRunningTotal

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
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.