Selected parameter date in power BI paginated report is not showing .
Hi Team , We are facing issue with power BI paginated report ,Selected date parameter is not visible to the user. But same is working on preview report button and process data accordingly . So we have the parameter as below : Selected parameter not vible but working on report process & visible in report. I have tried follwoing : 1. Updated reprort in the latest report builder and redeployed . 2. Tested in mulitple browser. This started from 3rd May 2024 . Report builder version :15.7.1807.730 Do let me know if anything else is needed here .
How to use a user input date serial number in another calculated column
Hi! I wanted to let the user to input a date and do a column calculation based on that date. To achieve this, I added a parameter slicer, where the user input number would be the serial number of the target date, as we are only allowed to input a whole/decimal number but not a date as a parameter. The parameter table was Base Date, the series column was Date (Serial Number), and the selected value was captured in Base Date Value. Base Date Value = SELECTEDVALUE('Base Date'[Date (Serial Number)]) However, when I used Base Date Value in calculation of a column, the calculation seemed not working: Here, I want to compute, under each contract, the total spend amount of invoices whose Final Approval Month (which is a date in fact) is within the 365 days before the BASE DATE selected by user. I calculate the difference between the serial number of the approval date and the input serial number and compare it with 0 and 365. Basically, the calculation gives me a blank column. Just for testing purpose, if I use TODAY() as the base date and compute the column as followed, it works and gives me some values. How can I use the Best Date Value in the calculation of the column to achieve my goal here?
Cascade Parameter in powerbuilder
I have a couple of Parameters that does not refreshing after the first time using. in other words, it is a date range parameter, that update a startmonth and EndMonth parametes, but If I choose antoher option from Date range parameters the other ones do not change. the Startmonth and endmonth it is a query with a @daterange parameter.
Date picker values for passing as parameter values
Hey, I have been trying to pass date values from a date slicer(can also be used as a date picker) but does not happen to work and for that reason I have to populate a list of dates from a certain year to select date values. This approach is not feasible from User-experience point of view. Are there any updates or would power bi be addressing this issue any time? Any help will be much appreciated. Thanks!
Date Parameter Showing up list
Hi Community, I am using Power BI Report builder and I have to create one start date and end date parameter which should be < Today(). I have created two different Dataset each for start Date and end Date and Passed in "Available Values" Section of paramters. But unformatunately instead of Calendar it is not showing up list. I tried Cdate(Fields!Date) expression as well and somewhere i read Calendar will not work if we pass available values. What is the workaround to Provide Date parameters where users can select dates prior to today only? Thanks, Pravin
