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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.