R Data Table - Support
Power BI custom visual by David Eldersveld
Contact me on Twitter - @dataveld
Log an Issue on GitHub
Based on the DT package, rDataTable is an interactive Power BI R custom visual that helps you easily explore table data.
Functionality
Some of the benefits of rDataTable include:
- Search
- Global search field to filter data across all columns
- Global search field to filter data across all columns
- Pagination
- Use “Show # of entries” to choose between 5, 10, 25, 50, 100, or 1000 records to display per page
- Use “Show # of entries” to choose between 5, 10, 25, 50, 100, or 1000 records to display per page
- Column-level filters
- Conveniently filter column values using the option below each column header
- Conveniently filter column values using the option below each column header
Format Options
Under Format, a section called Visual Settings contains various format options:
- Initial Entries - Choose the default number of entries/records per page
- Filters - Choose how to display the column filters (Top, Bottom, None)
NOTES
- User-defined selections and filters are not preserved between sessions. When used in a report, the initial view will appear with all of the data specified under Values (defaults to 5 entries to page, no in-visual filters applied, no search value). This limitation makes it a good exploratory but not necessarily a good explanatory visual.
- Optimal visual height is 415px or greater.
Environments
Power BI Desktop
rDataTable requires the htmlwidgets and DT packages installed in your local R environment to work with Power BI Desktop.
Power BI Service
All required packages are currently available in the Power BI Service. rDataTable runs in Power BI Service and has been tested in Chrome, Firefox, and Edge.
Power BI Mobile
rDataTable runs as a fully interactive visual in the Mobile app and has been tested in iOS (Android testing still needed).
Embedded or Publish to Web
This functionality is not available to any R Visuals in Power BI as of July 2017.
Changelog
- 1.1.0 - October 10, 2017
- Corrected issue where unicode characters were not appearing correctly
- 1.0.1 - July 15, 2017
- Added Format options for Initial Entries and Filters
- Adjusted Dependencies.json