Default values for slicer
Hi All I am pulling out what little hair I have left with this particular issue related to setting the default value of a slicer for a dashboard that has been configured for Dynamic Row Level Security. Here is my scenario. I have created a dashboard for dynamic row level security using the bridge table technique and then I have published the dashboard to our in house report server (not the service) and tested the data displayed using myself and another member of the team. There is a slicer setup as a single select to choose one of Company A,B,C, or D, It has to be a single select because the data is specific to one company not multiple. I have access to see Company A and B and my team member has access to see Company C and D. All this works perfectly and when I sign on I see A and B and my team member can see C and D. But when I published the dashboard, Company A was selected (because its the first one in the list) and this gets persisted with the published dashboard. Now when my team member signs on she sees that Company A is selected in the slicer and C and D are listed below it. No data is returned for A but its annoying because she only should see C and D. Now for rant time...... When is Microsoft going to sort out this defaulting issue for slicers. There are so many work arounds for defaulting date periods for latest month, etc and I am sure there is a workaround that some clever person is going to give me for my above problem 🙂. BUT SSRS and now even Paginated Reports have had this for ages by having a separate query that is used to supply the default value for a single select or multiple select parameter. When is this seemingly simple idea going to filter or bubble up to the top of the ideas list. I, and most probably half the Power BI family across the world have votes for this but nothing yet. Please Microsoft, you have a wonderful product and all the better now that Fabric has landed but please give us an easier out the box method to have default values for a slicer. Feel better now, comments appreciated.
"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?Slicer Header - For Date (No visible on Power BI Report Server)
Hello, Is it possible to modify the date slicer directly on the Power BI report Server portal ? It is available in Power BI Desktop, but once deployed, the arrow is no longer visible. In Power BI Desktop : On Power BI Report Server Portal : Thank you in advance for your help, Have a nice day, VivienDrill down selection not changing the slicer
Hi All, I have a report created where I have a clustered column chart with a drill down and a few slicers. When I am drilling down or up into the chart, the slicer values are not changing as per the chart drill down or up. Can somebody please help? For example, if I have a column chart showing sales every quarter and if I drill down, then the month-wise sales is displayed. Additionally, I also have a slicer for quarter to select. When I drill down to Q2 in the chart, my slicer should change the options to show only Q2 selected. Regards, RutujaVisual "slicer" - frame missing on Report Server
Dear community, we are using the Power BI Desktop RS version May 2022 and the Report Server version May 2022. After installing the update, we have recognized problems with the visual "slicer" (German "Datenschnitt"). There are new options for the frame: We have set all the options on the right side "obere", "untere", "links", "rechts". In Power BI Desktop, everything is fine. After uploading the report on the report server, the frame is missing: We have tested with Firefox, Edge and Chrome. Anyone else with the same problem? Thanks for your help. All the best Johanna
