In this Guy in a Cube video, Patrick looks at a small feature called slicer restatement in Power BI. This feature will help you to determine what was selected in a slicer. While this feature was added back in April 2018, most folks don’t know about slicer restatement.
Another great update to an already awesome tool.
From the video description:
This month we are very excited to integrate our Q&A experience into the reporting canvas, offering a whole new way to create your visuals. We are also updating our bookmarking preview with new features that provide you much more flexibility. A highly requested feature, the ability to drill to filter other visuals on the page, is also coming out this month. You can take advantage of several new connectors and major updates to existing ones.
Press the play button below to listen here or visit the show page at DataDriven.tv
Frank and Andy talk with Kira Wetzel about girls+data, running, Harry Potter, and the stream of consciousness.
Sponsor: Enterprise Data & Analytics
- Frank’s home improvement (2:15)
- Kira’s LinkedIn profile (4:00)
- Girls and Data (4:30)
- Data Point: Girls and Data at SQL Saturday Charlotte (5:12)
- Tableau (6:00)
- SAP = “Say a Prayer” (9:30)
- Tourist-y stuff (12:00)
- “Quaint” (13:00)
- “Data found me.” (13:30)
- TI-99, Q*bert, and BurgerTime (16:40)
- Girls and Data (18:45)
- “Try your vegetables” (22:00)
- Andy is right here… (22:15)
- Shoutout to SQL Cruise (Now Tech Outbound)! (26:15)
- Richmond SQL Saturday is 24 Mar 2018 (29:00)
- Running, sleeping, and eating (30:30)
- Girls on the Run (31:20)
- Technology is literally changing the world everywhere you look. (32:05)
- VR Vacations (33:55)
- A stealthy Microsoft Store visit… (35:45)
- Running calms the mind. (38:15)
- @girlsanddata (39:00)
- Stream of Consciousness and the Harry Potter question, again (41:00)
- Kira listens to Data Driven (42:45)
- Is “novitiate” the name of a young wizard? (44:00)
The November 2017 updates see conditional formatting get a major update with the ability to control the color based on rules.
If you have a slow data source, there are now report options that help limit the number of queries that are sent to the source.
Finally, there are several new formatting features, including cell alignment for table and matrix, and precise control over the order of overlapping charts on reports.
Adam from Guy in a Cube has a great PowerBI roundup video he just published.
Check it out. Links below the video.
- Exploring The New SSRS 2017 API In Power BI (@technitrain)
- Bulk-extracting Power Query M-code from multiple pbix files in Power BI (@TheBIccountant)
- Automatic installs of Power BI Desktop (@CurbalEN)
- How administrators can manage the Power BI Desktop sign-in form
- Visualizing and interacting with your Azure Machine Learning Studio experiments
- Congratulations to the Winners of the “Timeline Storyteller” Contest!
- DAX UNICHAR Function in Power BI (@ExceleratorBI)
- DirectQuery in Analysis Services: Best practices, performance, use cases (@marcorus)
- Change your Power BI report to point to an external SSAS model (@kjonge)
- Filtering and comparing different time periods with Power BI (@FerrariAlberto)
- Image Timeline (@dataveld)
Timeline Storyteller, a new custom visual for Power BI created with a team of researchers at Microsoft, is now available in the Office Store for anyone to use.
Although the primary audience for this custom visual was journalists, anyone can make interesting use of this handy tool.
The September 2017 update includes two features that were demoed at the Data Insights Summit: drill through and report insights.
There’s also an update to the theming preview and a new chart type!