COUNTROWS Not Working After Filter Pane
Hi Guys, HOWMANYLEFT = COUNTROWS(wyscout_bio_data) I have a matrix visual in my report. When filtering is done through Slicer, the above formula tells how many rows are left in the table. However, when filtering through the filter pane, the number does not look correct. What should I do?
Seeing selected date range in a card visual
I want to show a card visual on the home page of the repport that shows the YearMonth range selected in the filter pane. I have a DimDate[MonthYear] filter on all pages and have a current selection of Jan/19 until Oct/19. This is what i want displayed in my card visual as "Jan/19 - Oct/19". Ofcourse the visual had to change depending on the filter that changes. I already have the following DAX formula but this one gives me "Oct/19 - Oct/19". I can't figure out what i have to change to get my desired outcome. Selected YearMonth = VAR MinYearMonth = CALCULATE( SELECTEDVALUE(Dim_Date[Month Year]), FILTER(Dim_Date, Dim_Date[YearMonth] = MIN(Dim_Date[YearMonth])) ) VAR MaxYearMonth = CALCULATE( SELECTEDVALUE(Dim_Date[Month Year]), FILTER(Dim_Date, Dim_Date[YearMonth] = MAX(Dim_Date[YearMonth])) ) RETURN MinYearMonth & " - " & MaxYearMonth
Filter Pane on Public Power BI Report
A colleague has create a report that I used to see the filter pane for. He did not make any changes, though the filter pane is completely missing now (not collapsed, actually missing completely) I cannot see any option to show/hide the pane. How do I reset the filter pane so that it shows up again?
Filter pane in reports display differently after upgrade of Report Server
Hello, I've recently upgraded Report Server from August 2018 to September 2019. I've also upgraded Power BI Desktop optimized for Report Server to September 2019. When I open an existing report in Report Server, the Filters pane for that report gives me the options to perform a basic filter or an advanced filter. However, when I edit the existing report in Power BI Desktop (Sept 2019) and republish the report in Report Server, the Filters pane does not display the basic filter or advanced filter options. Screenshots below. On another note, if I create a new report in Power BI Desktop (Sept 2019) and publish to Report Server, the basic filter and advanced filter options display in the Filters pane. Is there a reason after modifying an existing report and republising it, the filter pane behavior is different? Is there a way to fix this? I can imagine, users will want the ability to change the filter on the page. Moreover, I've also tested publishing an existing and new report created/modified in the August 2018 version of Power BI Desktop to Report Server (Sept 2019). I was expecting an error of some sort since the versions are different. Does the Sept 2019 version of Report Server allow you to publish reports created in previous versions? Report created in Aug 2018 version Report modified in Sept 2019 version
Can You Change the Width of the Filter Pane on Power BI Report Server?
We have several users that would like to change the width of the Filter pane as it's displayed alongside reports on our on-premise Power BI Report Server. Is the width of the Filter pane something that is configurable on the Power BI Report Server? If so, can you please provide a linkTurn off Horizontal and Vertical scroll bars with Filter Pane
Hi, Filter pane is a nice addition. However the scroll bars that show up are annoying. Horizontal scroll bar prevents user from clicking the report pages. Vertical scroll bar is just too confusing as it shows up right next to the visuals(which can have scroll bars too). I have tried different page views, aspect ratios for the page and tried adjusting the page size by specifying width and height. I had expect not to show scroll bars when "Fit to page" is selected. We can find blank padding space after filter pane (on scrolling to extreme right) Please provide a fix for this bug as soon as possible. Thanks, Mannu
PowerBI Report Server and the New Filter Pane
Hi, Just occured to me that not everyone will have realised this, but you can use the new Filter panes in Jan 19 PowerbI Report Server and I'm guessing the just released May 19 version. The Powerbi Desktop for Report Server doesn't allow you to enable the filter pane as it's a preview feature. However if you enable in the normal desktop version then load into the Report Server Version it stays available. Once published/uploaded you can also still use the Filter Pane. I used it with this comparison tool which works well on my Jan 19 PBIRS https://github.com/stretcharm/PBIDataComparison
