Power BI Slicer - Between Dates don't get the latest date
Hello everybody!! I need some help with the date slicer on Power BI Desktop. When I create my Dashboard, I put an slicer between two dates, that are my first and last date based on my Calendar table (it's based on my first ticket creation date, on my tickets table, and "today" function). After, I publish it on my Report Server, set the schedule refresh, everything is okay. But on the next day, when I'll check the Dashboard, after the refresh, the last date wasn't the most recent date (or today, in that case), but the date when I published the Dashboard, so the viewer needs to slide the filter to the right to get the actual date, or click on the "clean filters" button. That's the example of date filter that I'm using. It was published on Jul,11 (it's on Brazilian format), and the second image, is the today refresh. Note that the first date changes too, because the Dashboard was published with data from Apr, 11 2019 to Jul, 11 2024, so at the refresh, my source data was only after Jan, 2 2023 There's some solution based on this? I've the latest release of Power BI Desktop and Report Server, but I didn't find any settings to do that. I've searched in a bunch of topics here, on Stack Overflow, Reddit, but didn't find anything specific for that.
Filter Date Column by multiple criteria
I have a Date Column in Power BI that displays dates in the typical dd/mm/yyyy format. I would like to display, on a bar chart, the following: One bar that sums the # of people that have a date between 03/25/2024-10/24/2024 and another bar that sums the # of people who have a date on or after 10/24/2024 Thanks so much.Issue with Multiple date keys and displaying dates on report.
Hello, i am working on a SSAS Tabular model to support Power BI report development. Our main fact table has multiple dates (Order Date, Paid Date, Shipped Date) with the Order Date being the active relationship to the date dimension. One of our reports requires a table that has the following columns (amoung others) Date and Amount by Paid Date. I understand how to build the measure "Amount by Paid Date" using USERELATIONSHIP to active the relationship between my fact.paid_date_key and the dim.date_key. Other than fully duplicating my date dimension to have a "Paid Date Dimension" and use that inactive relationship. how can i include "Paid Date" in my report table?
Date Issue on chart
Hi. I have a chart with a date which looks fine in Powerbi but as soon as I publish a report, the dates all splay out into random months which aren't even in the date field. The actual month_year column is a string field which is formatted from a date column and ranked by a separate YYMM column. Can't figure out why I'm getting this display issue - is it a powerbi bug? Any help would be greatly appreciated. Thanks, In BI desktop: In Bi when published: Data:
