Build a custom visual for Microsoft Power BI

Build a custom visual for Microsoft Power BI and Excel from scratch in 15 minutes Jan Pieter Posthuma Data. Scenarios mail@datascenarios. nl Power. BIWorld. Tour. com #PBIWorld. Tour

Session Agenda • Introduction • Developing • Demo – Custom Visuals • Demo – Custom visuals in Excel Power. BIWorld. Tour. com #PBIWorld. Tour

Jan Pieter Posthuma • • Microsoft Data Consultant Data. Scenarios – Data Consultancy Company Architect roles at multiple projects Creator of Power BI Custom Visuals • Hierarchy. Slicer [∞] • Box and Whisker chart [∞] • D 3 js Visual [∞] • Contact • • mail@datascenarios. nl https: //twitter. com/jppp https: //linkedin. com/in/jpposthuma https: //github. com/liprec Power. BIWorld. Tour. com #PBIWorld. Tour

Power. BIWorld. Tour. com #PBIWorld. Tour

Power BI Custom Visuals Platform Debugging and testing Developer tool Open Source See what you code APIs & Utils Sideload into Power BI to test anytime, anywhere Import D 3, j. Query, Web. GL, etc… https: //github. com/Microsoft/Power. BI-visuals-tools R scripting Marketplace Advanced analytics visualizations Developer portal Interactive Global reach - Power. BIWorld. Tour. com Integrated into PBI clients #PBIWorld. Tour

The Business Value of Custom Visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Why Develop Custom Visuals? Build a unique expertise in the BI solution providers domain Enrich your solution portfolio Eye catching reports and dashboards – Go beyond the usual pie/bar charts Power. BIWorld. Tour. com #PBIWorld. Tour

Custom visuals partner offerings https: //appsource. microsoft. com/en-us/marketplace/consulting-services? page=1&search=custom. Visuals. Offer&country=US Power. BIWorld. Tour. com #PBIWorld. Tour

Development Power. BIWorld. Tour. com #PBIWorld. Tour

• Node. JS 5. 0+ Required. (v 5 – 8 are confirmed to work with pbiviz) • https: //nodejs. org/ • Power. BI-Visuals-Tools • npm install -g powerbi-visuals-tools • Create and install user SSL certificate: https: //github. com/Microsoft/Power. BIvisuals/blob/master/tools/Certificate. Setup. md • Visual Studio Code • https: //code. visualstudio. com/download • PBIViz CLI addin: https: //marketplace. visualstudio. com/items? item. Name=liprec. vscode-startpbiviz • Enable ‘Developer Visual’ in Power BI user settings Power. BIWorld. Tour. com #PBIWorld. Tour

Power. BIWorld. Tour. com #PBIWorld. Tour

Power. BIWorld. Tour. com #PBIWorld. Tour

Create Code Your favorite IDE APIs Test Package Submit Power. BI. com Learn more: https: //github. com/Microsoft/Power. BI-visuals Power. BIWorld. Tour. com #PBIWorld. Tour Feedback

What’s new in custom visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Report page tooltips Enable users to use page tooltips Power. BIWorld. Tour. com #PBIWorld. Tour

New Documentation Site For Developers • Developer Center: https: //powerbi. microsoft. com/en-us/developers/ • New Github. io: https: //microsoft. github. io/Power. BIvisuals/docs/latest/overview/ Power. BIWorld. Tour. com #PBIWorld. Tour Grow the ecosystem

API version 2. 1 New version tooling with • Typescript 2. 8 support • ECMAScript 2015 (ES 6) modules support • Webpack support Roadmap • Multi. Column Json. Filter Power. BIWorld. Tour. com #PBIWorld. Tour

Demo – Custom Visuals Power. BIWorld. Tour. com #PBIWorld. Tour

Custom visuals in Excel • Integrate into Excel’s Charting experience • Expand your potential audience • 100’s of millions of Excel users worldwide • Write Once, run in both Power BI and Excel • Let’s see it in action… Power. BIWorld. Tour. com #PBIWorld. Tour

Demo – Custom visuals in Excel Power. BIWorld. Tour. com #PBIWorld. Tour

Custom visuals in Excel – Key Points • Expand your potential audience • 100’s of millions of Excel users worldwide • Intuitive insertion experience • All Chart users are potentially Custom Visuals users • Tailored store experience • Focused on just Custom Visuals • Common UI controls • Consistent experience across all visuals • Enterprise Ready • Deploy it just like any Office Add-in Power. BIWorld. Tour. com #PBIWorld. Tour Now pub in Prev lic iew

Supported Features • Unsupported features are ignored in Excel workbooks. • You only need to build one visual for use in both applications. • Custom visuals connect directly to data, therefor: • Must be a contiguous range of cells • Oriented with data fields as columns and records as rows • Pre-processed with any desired calculations (including aggregations) Capabilities • data. View. Mappings: Categorical • Basic object types: bool, enumeration, fill, integer, numeric, text • API Methods/Properties : persist. Properties, color. Pallette Power. BIWorld. Tour. com #PBIWorld. Tour https: //microsoft. github. io/Power. BI-visuals/docs/latest/building-for-excel/supported-features/

Sign-up for Custom Visual updates at http: //aka. ms/xlcvdev Power. BIWorld. Tour. com #PBIWorld. Tour

Session resources https: //www. powerbi. com/visuals/ https: //docs. microsoft. com/en-us/power-bi/service-custom-visuals-getting-started-with-developer -tools https: //github. com/Microsoft/Power. BI-visuals-tools pbicvsupport@microsoft. com https: //aka. ms/customvisualscommunity https: //www. microsoft. com/handsonlabs/Self. Paced. Labs/? storyguid=5 B 4 E 7144 -F 5 CB-4412 -B 06 A 893782 B 1 C 403. com Power. BIWorld. Tour #PBIWorld. Tour

Power. BIWorld. Tour. com #PBIWorld. Tour

Don’t forget to join your local PUG to enjoy year-round networking and learning.