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.
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:Sorting columns from last year/last month on the left to this year/last month on the right
I have a column chart where it shows the month closed for the past 12 months. It is now the beginning of April 2024, so I want it to go, from the left hand side, April 2023 to March 2024. Instead PowerBI will show it from January to December where January is in 2024 on the left and December 2023 is on the far right. This is confusing for users. (I think that will make sense when you look at the image of how it is displayed today.Stop date field format changes in report ?
Hi, On my desktop app my date format for my date fields is: 'dd MONTH yyyy' for example: '09 January 2023' but on the published report it changes date fields to a different format: 'DAY OF WEEK, MONTH dd, yyyy' for example: 'Monday, January 09, 2023' I don't want this. Any ideas how I can fix this? Thanks!
Power BI Report server change my date fields
Hi, guys, I have a problem with Power BI Report Server (PBIRS). I have a DATE column in my PBIX that is changed when it is refreshed in PBIRS. It is a DATE field, not calculated. Comes directly from my table in MySql. Working locally using Power BI Desktop for Report Server (PBIDRS), the dates look normal. Let's say that I refresh my PBIX and none of the dates in my column are greater than the time I am running it. If I publish the dashboard in Web Services, dates look normal, even if I refresh the dashboard. But, if I publish the dashboard in PBIRS, while it is not refreshed, the dates are normal, but when it is refreshed by schedule, the dates jump 5 hours ahead. If we were talking about a calculated refresh date, I know I will receive a UTC date. That is the server’s way. But why MY data? Is like I am using a sales amount and the server is modifying MY TABLE data adding a fixed amount to it. Any idea on why this is happening?
Filter Matrix Table by Relative Value to DAX Dynamic Date Rank Measure
Hi All, I have successfully created a RANK measure (DateRank) thanks to powerBI forum that will dynamically adjust with slicer selections. I must now create a table that will respond relative to that Rank, specifically, MIN(DateRank)+1 or DateRank = 2. DateRank = MINX ( FILTER ( SELECTCOLUMNS ( ALLSELECTED ( 'Table' ), "index", 'Table'[Index], "rank", RANKX ( ALLSELECTED ( 'Table' ), 'Table'[Report_Date],, DESC, DENSE ) ), [index] = MAX ( [index] ) ), [rank] ) This is due to a report which will only run certain days of the week (not weekends). Report_Date corresponds to the report output of the specified date, and when selecting a Report_Date through a slicer, we would like to affect two tables: one which displays selected Report_Date PV (present value) and one that displays the immediately preceeding Report_Date PV. For the supplied PBI data, when 12/14/21 is selected on the filter, the "Selected Date" table will display PV as of 12/14/21, and the "Previous Date" table will display PV as of 12/14/21. Using the DateRank measure, I have tried to filter "Previous Date" on DateRank = 2 using Filter pane, and also a measure [PV_Yesterday] where DateRank = 2, but niether are working. I would prefer to Filter on DateRank = 2 or an equivalent solution, but if new measure is required like [PV_Yesterday] instead of a visual filter, then I am open to that. Thank you for considering this problem! Report_Date REGION PV 10/25/2021 12:00:00 AM MID-WEST -1584657.012 10/25/2021 12:00:00 AM NORTH-EAST 47711338.72 10/25/2021 12:00:00 AM SOUTH-EAST 0 12/14/2021 12:00:00 AM SOUTH-EAST 0 11/10/2021 12:00:00 AM NORTH-EAST -2920107.499 11/10/2021 12:00:00 AM MID-WEST 0 11/29/2021 12:00:00 AM NORTH-EAST -15895241.11 12/6/2021 12:00:00 AM MID-WEST 0 12/9/2021 12:00:00 AM MID-WEST 0 11/11/2021 12:00:00 AM NORTH-EAST 0 11/11/2021 12:00:00 AM MID-WEST 0 12/8/2021 12:00:00 AM NORTH-EAST 2.015367962 12/1/2021 12:00:00 AM NORTH-EAST 0 11/17/2021 12:00:00 AM NORTH-EAST 0 11/1/2021 12:00:00 AM NORTH-EAST -1160.720229 10/28/2021 12:00:00 AM NORTH-EAST 0 11/5/2021 12:00:00 AM NORTH-EAST -1033717.772 11/23/2021 12:00:00 AM MID-WEST 0 11/23/2021 12:00:00 AM NORTH-EAST 134.1285225 11/8/2021 12:00:00 AM NORTH-EAST 0 11/22/2021 12:00:00 AM MID-WEST 0 11/19/2021 12:00:00 AM NORTH-EAST -798412.6336 11/19/2021 12:00:00 AM SOUTH-EAST 0 11/16/2021 12:00:00 AM MID-WEST 0 11/15/2021 12:00:00 AM MID-WEST 0 11/12/2021 12:00:00 AM NORTH-EAST 0 11/12/2021 12:00:00 AM MID-WEST 0 11/9/2021 12:00:00 AM NORTH-EAST 2.193014276 12/14/2021 12:00:00 AM NORTH-EAST -11874298.76 11/19/2021 12:00:00 AM MID-WEST 0 11/10/2021 12:00:00 AM SOUTH-EAST 0 11/16/2021 12:00:00 AM NORTH-EAST -140.1228899
