slicers
9 TopicsSlicers not visible in focus mode
Hi, I want users who view the reports in Report Server to be able to see which slicer choices are in use when they enter Focus Mode and choose to print the page. Or is there any way a user can print a specific visual with all the data visible along with the slicer choices that are in use? Can I somehow custom make Focus Mode through PBI Desktop? BR Emma1.4KViews0likes2Commentsundefined
Hi, Could anybody please help me with the below I have three tables 1) Course table(has Roles, CourseName and uniqueID assigned to Course) 2) Employee Table(Employee name, CourseName and UniqueID assigned to the coursename). This table gives the the courses completed by the employees based on their Roles I need to build SSAS model, when I select the Role(1st slicer) - CourseName related to the roles should pop up. (2nd slicer is employeeName) when I select EmployeeName among those Coursenames if there is anything he/she completed it should show green or else Red how do I build this466Views0likes0CommentsSlicer values misaligned
Hi We're using May 2021 Report Server (1.11.7815.26414) with Edge 93.0.961.47 and we're experiencing the same issue as per this message: https://community.powerbi.com/t5/Developer/Slicer-Dropdown-mis-aligned-in-embedded-using-Chrome-v93/m-p/2063740 Does anyone know if this issue is fixed in the September release of Report Server? Many thanks1.1KViews0likes2CommentsAnchor date on Slicer
I have a date slicer in my report that will allow the user to select any date or date range they want to view. However I want the default view to always be the most recent date only. The data gets updated every night. So for example today is 3/10 so the most recent date in the data set will be 3/9 and I want my date slicer to show 3/9-3/9. Tomorrow on 3/11 the most recent date is 3/10 but currently the slicer is showing 3/9-3/10 and this gets worse as time goes on as the start date on the slicer stays with whatever I uploaded the file as while the end date updated to the most recent. The most important aspect is that I need the end user to be able to select any date or date range that exist in the data but have the default be a single day view of the most recent info. Any thoughts? Thanks.Solved2.7KViews0likes1CommentMultiple slicers multiple selection not summing to the correct value
Hi, I have 2 different slicers each having different products; say Slicer 1 has 3 products-A, B, C, and Slicer 2 has 3 products-D, E, F. When I am selecting All values from both slicers it's giving me a correct cumulative added value in the card. But if I select any 1 or more values (but not all), the card value gets adjusted only to one slicer and doesn't give value summing up the selected values of both the slicer. Can someone please help me with this? calculate('Metrics'[Revenue], filter('Product',Product'[Product X]in {"A","B","C","D","E","F"}),FILTER('Calender','Calendar'[Quarter] in {2020Q1,2020Q2})) . This is my table: A 10 B 20 C 5 D 5 E 25 F 35 This gives correct no. in the card 100 100 Slicer 1 Slicer 2 All All This gives wrong value, it should give 110, instead, it's giving only 10 10 Slicer 1 Slicer 2 A All674Views0likes0CommentsVanishing Slicer Data, differing User Experiences
We use a dashboard with multiple interrelated date filters. Today, while using the dsahboard, I adjusted the month slicer by removing checked months to narrow the focus. When I did, those month disappeared from the slicer and could not be brought back. I've tried refreshing the dashboard page, refreshing underlying data, rebooting my PC, accessing through different browsers, clearing browser history and cookies, and opening the desktop version as well. None restored the slicers to functionality. Oddly, no other users are having the same issue. The same behavior occurs in desktop Power BI. I'be tried adding a new slicer and associating it with the same data. When added, it shows no data though there is data in the underlying table. Help?!618Views0likes0CommentsPersistent Filters on Sync Slicers
Hello, We have a report that has a landing page with slicers that are synced to other tabs. When a user has selected something on Tab 1, and comes back to the landing page to change the filtered option, the selected option on Tab 1 does not go away. The user has to deselect the option on Tab 1 to make it go away, which creates confusion for the users. Is there any way to remove this persistency, so that when the selection is changed on the landing page, all the tabs are automatically updated and the previously selected options are void? Regards, Shubhangi Agrawal510Views0likes0CommentsSlicer breaks other visuals when has a value selected
Hi everyone I've created a dashboard in PBI Desktop and works here with no issues at all. But, when I open this report from my PBI Report Server I face the following issue with a slicer: If no value is selected on the slicer, it is shown like this: But if I select a value on the slicer Customer Success Manager Name. I get the following: I don't know what might be causing this issue. The logs don't show much information and the error message when I click on See details are: An unexpected exception occurred. Please try again later or contact support. If you contact support, please provide these details. Request ID36bf61a6-888e-a239-f310-d3b58b5946e1 TimeThu Mar 07 2019 10:53:30 GMT-0500 (Eastern Standard Time) Version15.0.2.557 Which gives me few lights about what might be happening.721Views0likes0CommentsQuestions regarding retaining slicer values for on-premise PBI & Sharepoint
I have received the following questions for an On-premise Power BI solution using Report Server and Sharepoint as a frontend Portal: - Can slicer values in a Power BI report be saved for future use? (Say the user has used slicers to filter in a report. The user would like to save the slicer values for future usage.) - Can the same user send the filtered report to a colleague while maintaining the slicer values? Any help is appreciated! (I did find this link but this might only apply to the Power BI Service)948Views0likes0Comments