Report Builder keeps saying I have a parameter that I actually deleted
Hello, I am trying to build a report in Report Builder and have hit a snag. I am working with car insurance data. I have a boolean variable called "IsClaimOpen" that I turned into a parameter using my dataset Query Designer. (The values are Yes and No.) Report Builder called it "ClaimIsClaimOpen" by default. For clarity I went into the Parameter Properties and changed the name to simply "IsClaimOpen". All good so far, right? Wrong. When I ran the report, I received the following error message (with a buffering symbol and a "Loading..." message behind it): So I decided to go back and find out what the problem is. But not before playing around a little with the report. Once I got rid of the error message, the canvas showed me this error message: But I WAS able to select Yes or No from the parameter. If I hit "View Report", though, it would bring up the same error message as before, again with a buffering symbol and a "Loading..." message behind it. First I opened the Parameters folder on the the Report Data pane. There was one parameter there, labeled "IsClaimOpen". Then I went into the Dataset Properties window and then the Parameters section. Again, there was one parameter there, labeled "IsClaimOpen", with the expression "=Parameters!IsClaimOpen.Value(0)". I even tried running the report again, only to be taken to the same canvas as before. So I went back to Designer view and opened up Dataset Properties, because surely there was something I missed! I opened up Query Designer and browsed a bit, but I couldn't find anything. So I closed the Query Designer window and navigated to the Parameters tab of the Dataset Properties window. There I found the problem. There were two parameters listed. The second was named Is_Claim_Open and had the same expression as the one I named IsClaimOpen, but the first was called ClaimIsClaimOpen and was blank! I deleted this parameter immediately, and then ran the report again. But I got the same result as before. Does anyone have an idea what is causing this or how I can fix it? Thanks, Joe
Power BI Report Builder - Distinct Parameter Values while maintaining Data Model
Hello, I have read so many blog/ forum posts on this but I can't for the life of me get this working, so I really appreciate any help. I am creating a Paginated Report, which is linked to a Power BI Dataset that has two tables which are linked together. I want cascading parameters, and this works if I add the parameters by right clicking the Parameters folder and selecting Add Parameter, then getting Available Values from a Query pointing to the relevant table . Done this way, the selection I make in my first parameter limits the options available in the second (yay) EXCEPT that the values in the parameter drop down are not DISTINCT, so I literally have the same option appearing 20+ times: If I add the parameter when creating my datasets (by dragging a field into the Parameters section in the Query Designer) then I get DISTINCT values, but the first parameter no longer filters the second. To try and resolve this I have created separate tables that have DISTINCT values using a Query like the below: DEFINE VAR DistinctValuesTable = SUMMARIZE ( FILTER ( 'EntityGroup', EntityGroup[Organisation] = SELECTEDVALUE(@EntityGroupOrganisation) ), 'IndicatorHandbook'[Corporate Plan / Annual Report] ) EVALUATE DistinctValuesTable Then I set the Available Values for the parameter to this table, which does remove duplicates but the issue remains that the options in subsequent parameters are not affected by earlier selections. Any help would be greatly appreciated. I can't figure out why this would be so difficult, surely no-one wants the parameter options to work this way by default?!
Have a Line Chart Ignore Parameter Selected
Hello, I am trying to achieve having a line chart that shows the average revenue of the company selected. My only issue is that the two parameters that I have on the top of the report are DATE & COMPANY. Now I want the entire page to load off of the DATE & COMPANY selected, but for the line chart. I want this to just be affected by the COMPANY selected but show all data for all dates. Basically I am attempting to see the average of the revenue over time in this line chart, while having the rest of the report be filtered to the selected date parameter. Any help on this would be greatly appreciated.Report Builder And/Or Parameters
I need some help. I am needing a way to set parameters for a paginated report that are an OR situation. The example is a report that shows the invoices that were created or paid within a selected month. Sample data: Invoice # Create Date Paid Date S001 1/15/2023 2/15/2023 S002 2/10/2023 4/2/2023 S003 2/11/2023 3/5/2023 S004 3/5/2023 3/15/2023 S005 3/8/2023 S006 4/10/2023 They need to be able to select parameters for the Create Date start and end as well as the Paid Date start and end. An example would be for the month of March. Create Date parameters would be 3/1/2023 to 3/31/2023 and the Paid Date Parameters would be 3/1/2023 to 3/31/2023. We want the report to return Invoices S003, S004 and S005. I have been able to get the parament range to work for one or the other or both together, but am having trouble getting it set for OR. Please help. Thank you in advance.
