With the release of CTP 2.3 of SQL Server 2019 today there was big news for Analysis Services Tabular developers: Calculation Groups. You can read all about them in detail in this blog post:
Power BI Bookmarks, Synced Slicers and Selections; these features transformed the way we report using Power BI. Now, most of the business users want reports with actionable interactivity. Well, it has pros and cons; today’s post is not to discuss that but to talk about Synced Slicers.
Synced Slicers were one of the most requested features. As the name says, this functionality enables you to Sync slicers among various Power BI Report pages, and you can manage the properties of it under Sync Slicers Pane.
A common problem I see some people struggle with in Power BI is when a slicer contains a (Blank) record for some reason. The cause of the problem is not obvious and hence it is not clear how to fix it. This article describes what causes this to occur and also how to fix it (properly, and also with a work around if you can’t fix it properly).
There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers. When this happens, you only get half the page to visualise the actual data. But on the flip side, if you don’t have the slicers it can be harder for the report users to filter the data they want to see. Many users don’t like using the built in filter pane on the right hand side.
Here is the scenario. The user wants to select a product from a list. When that product is selected, they want to see a list of all invoices that contain that product AND ALSO see ALL OTHER PRODUCTS on those same invoices. The reason this is such an interesting problem is that normally when you select products from a list in Power Pivot, the selected products filter the data model hence you can only see sales for those selected products
My idea was that I would load school photos and also the reunion photos onto the one page. The user can then click on a slicer with someone’s name (or any other information about people) and “see” those people highlighted in the photo. I started thinking that I could use the excellent Synoptic Panel from The Italians for this. The only problem I could foresee was that Synoptic Panel is designed to provide shading over an image based on what was selected. I wanted to shade/hide those people that were NOT selected. Anyhow, I love a challenge.