March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
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:
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.
@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:
ReceivedTime | AgentName | EventCategory | EventName | EventDescription | RawText | ExtractedDate |
EventName | EventCount | EventCountRank | RunningTotal |
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |