Build a Basic Power BI Accordion Filter (or Don’t)

Reading Time: 4 minutes An accordion for a user interface is a control that expands a relevant section when a user makes a selection and collapses other sections that are not in focus. Whether you use slicers, filters in the filter pane, or crossfilter by selecting elements of visuals; Power BI has extensive versatility to filter data. The “accordion”-style…

Paginated “Custom Visuals” in Power BI Report Builder: Part 1

Reading Time: 4 minutes Microsoft’s Power BI [Paginated] Report Builder is the newly rebranded version of the venerable SQL Server Report Builder. These static reports have been around for years, but there’s still some room for innovation. For example, Power BI allows designers to import custom visuals into Desktop reports to enrich them beyond the default visual options. What…

Introducing the FUBAR Chart for Power BI

Reading Time: 1 minute The Funnel Bar (FUBAR) Chart for Power BI is a new concept that combines the versatility and inherent trustworthiness of the bar chart with the unpredictability of Power BI’s funnel visual. Why do people use funnels? It is well-established tradition that sales reports include visuals where an axis (usually the Y axis) has bars that…

5 Reasons Power BI Users Should Participate in Makeover Monday

Reading Time: 2 minutes Makeover Monday is a weekly social effort to help everyone in the data visualization community. Working primarily from data.world and tweeting with the hashtag #MakeoverMonday, this community strives to steadily improve the quality of data analysis and visualization at the individual and community level. There’s even a new book that grew out of the weekly…

R Pivot Table custom visual for Power BI - DataVeld

New R Packages Available in Power BI Service

Reading Time: 3 minutes Microsoft recently updated the R version for Power BI Service and installed numerous additional R packages. For comparison, I posted the then-current list of packages back in July 2017. If you use R in Power BI Service, definitely see what’s available in the screenshots at the end of this post. Hopefully the Power BI documentation…