PBI Report Builder - removing duplicate values in parameter dropdown
I'm currently working through building a paginated report with PBI Report Builder, but a small issue came up. One of my parameters is called Spend Year. Currently, for the sake of working with a faster loading file, I filtered this down to only include the year 2023. However, the issue with this is that the parameter dropdown is displaying multiple options for 2023. I believe it's displaying a 2023 for each row in the dataset that contains one. Having multiple options for the same thing just isn't practical, so I've been looking for a way to have the parameter dropdown display distinct options. I managed to find this article: https://www.c-sharpcorner.com/article/remove-duplicate-filter-values-from-ssrs-parameter-drop-down/. While this matches my situation, the VB code that he writes is for String values. I'm working with integers. I tried my best to adapt his code to work for integers (you can find the code below), but after following through everything, my Spend Year parameter is now greyed out with no selectable values. I was sure to configure the available values as detailed in the article. Does anyone happen to have any idea how I should go about this? If it's useful to know, my data was pulled via a DAX query. Thank you in advance! My version of the code: Public Shared Function RemoveDuplicates(parameter As Parameter) As Integer() Dim items As Integer() = parameter.Value Array.Sort(items) Dim k As Integer = 0 For i As Integer = 0 To items.Length - 1 If i > 0 AndAlso items(i) = items(i - 1) Then Continue For End If items(k) = items(i) k += 1 Next Dim unique As Integer() = New Integer(k - 1) {} Array.Copy(items, 0, unique, 0, k) Return unique End Function
"Date between" slicer appearing as a dropdown for user
Hi All, I have a Power BI report with a date range slicer, which I have set to the 'between' option. On publishing this to web, this works for myself and another colleague in my team. However, when another user uses the report they see a drop down instead. What we see: What they see: Why is this?paginated reports interactive parameter dropdown lists not displaying data
From 2022-03-31have interactive paginated reports stoped display data. The reports has worked before. After I choose parameter values from dropdown lists (From, To and Organisation) and push <View Reports> nothing happends . It seems like report is not running the query. The problem seems to be, that the choosen parameter values in the dropdown list is not used in the query. If I manually enter the the values in parameter boxes, if works, sometimes. I have tried to use different web browsers (Edge, Chrome, Fire Fox and Opera) and have the same issue. The "Power BI Embedded" service is Gen.1 in Prod environment and Gen.2 in Dev environment. When I use the local .rdl file, everything works.
Drop Down Filters Not Permitting Selection
In PBIRS in Chrome, Power BI Desktop (May 2019), and Power BI Desktop 2.70.5494.761 64-bit (June 2019) we are experiencing an issue with Drop Down Slicers. The issue does not occur in PBIRS in Edge or PBIRS in Internet Explorer. When selecting the drop down list the expanded list of options disappears (detracts) before a selection can be made. In order to recreate the issue, I click on the drop down selection list first and then move the mouse down to make a selection. The selection list disappears. In order to "resolve" the issue I click anywhere else in the slicer area including below, to the side, or on the title of the slicer, anywhere but on the select list. I then click the select list and I am able to choose a selection from the select list.
RDL report on Power BI server - parameter drop down lists doesn't open underneath dropdown
I have a report I created in Power BI Report Builder that's publishes to Power BI service. It has a couple of parameters that have drop downs - when I click to select from the drop down it appears of the far right of screen (not underneath the drop-down field). I have three drop downs, they all open in the same place.Showing group of dates filtered with slices
Hello all, I would like to get a line chart of the numbers of sales for a period like this one But I'd like to know if I can get the same, filtering the date in a list or dropdown slice, instead of a range of dates. This is the measure I'm using: sales = CALCULATE(countrows(sales);FILTER(sales;sales[salesdate]>=sales[salesdate]-7 && sales[salesdate]<=sales[salesdate])) Thanks in advance for your help
