upsetjs.github.io

UpSet.js as PowerBI Visual

This is a PowerBI Custom Visual for rendering UpSet.js.

This package is part of the UpSet.js ecosystem located at the main Github Monorepo.

see also Sample GoT PBIX file or Sample PBIX file

Installation

Download the latest package from https://upset.js.org/integrations/powerbi/upsetjs_preview.pbiviz and install into your PowerBI environment.

Data Roles

The UpSet.js visual has three data roles:

• Elements exactly one grouping with a unique identifier for each row (e.g., a name)
• Sets one or more measures or groupings which represent the sets. When it’s value at row i results in a trueish value (e.g., 1, true, …) UpSet.js will interpret it that the element at row i is part of this set
• Attributes zero or more numeric measures that are used to generate boxplots for each set intersection

In addition, the visual supports various styling options including the customization of how the set combinations are generated.

Interaction

The UpSet.js visual reacts to selections from other widgets by highlighting the elements in its chart. Moreover, when the user clicks on an element in the chart, the corresponding set (combination) will be selected.

Venn Diagram

In addition, there is a sibling extension for rendering Venn and Euler Diagrams:

see also Sample PBIX file

Installation

Download the latest package from https://upset.js.org/integrations/powerbi/upsetjs_venn_preview.pbiviz and install into your PowerBI environment.

Data Roles

The UpSet.js visual has two data roles:

• Elements exactly one grouping with a unique identifier for each row (e.g., a name)
• Sets one or more measures or groupings which represent the sets. When it’s value at row i results in a trueish value (e.g., 1, true, …) UpSet.js will interpret it that the element at row i is part of this set

In addition, the visual supports various styling options including the customization of whether a Venn or an Euler diagram should be generated.

Dev Environment

see also https://docs.microsoft.com/en-us/power-bi/developer/visuals/environment-setup

npm i
cp src/secrets.example.json src/secrets.json
npm run pbiviz -- --install-cert

Test Server

npm start

Commands

npm run lint
npm run fix
npm run build
npm run release

Submission

1. Create a new release
2. Update the sample dataset with the latest version
3. Send a mail to pbivizsubmit@microsoft.com. subject: Ultimate UpSet Plot vX.X.X content: ? attachments: the pbiviz and the sample report
4. Wait for app package XML response
5. Go to https://partner.microsoft.com/de-de/dashboard/office/products/d350d8dc-2e28-41b2-b7b4-87e8510b8dc7/packages and upload the new XML file
6. Check the package and Publish

Privacy Policy

UpSet.js is a client only library. The library or any of its integrations doesn’t track you or transfers your data to any server. The uploaded data in the app are stored in your browser only using IndexedDB. The Tableau extension can run in a sandbox environment prohibiting any server requests. However, as soon as you export your session within the app to an external service (e.g., Codepen.io) your data will be transferred.

License / Terms of Service

Commercial license

If you want to use UpSet.js for a commercial application or in a commercial environment, the commercial license is the appropriate license. Contact @sgratzl for details.

Open-source license

This library is released under the GNU AGPLv3 version to be used for private and academic purposes. In case of a commercial use, please get in touch regarding a commercial license.