Skip to main content

Using in Power BI

Difference from Original version of the visual​

The visual was split into two different visual (VIEW and EDITOR). The Editor has built in editor that allows to create charts from scratch. The View doesn't have built in editor and support only importing templates and mapping data.

Reasons for that:

  • The View is Power BI certified. And cannot access external resources.
  • The View contains less code than the Editor version and size of package is significantly smaller. It speeds up loading reports.
  • The Editor is not certified and there is no plans for certification.
  • The Editor is going to have public gallery of charts that will allow easily import charts made by community.

Don't use Editor version of the visual on the final reports for consumers.

Getting started​

You can import the chart design, exported as template, into Power BI. Once its required data fields are filled and mapped, you can see the chart within Power BI.

In addition, the chart reacts to the event from other charts or slicers. For example, you can create a slicer using the Month value of the DATE value so that you can interactively choose the desired month to be shown.

On Power BI report:

Power BI

Charticulator’s underlying framework handles data tables in a certain way, expecting data tables are formatted in a specific way. Some of the Power BI’s default behaviors do not satisfy the expectations and cause unwanted results. Here, we explain how to configure the settings in Power BI to meet Charticulator’s expectations.

Don't Summarize​

In Charticulator, a glyph represents one data row. For example, to create a bar chart, each row in the data table must correspond to one bar. On the other hand, Power BI “summarizes” data by default. For example, with the 200 mushrooms dataset, for a numerical data field (ID), Power BI automatically computes the Count, the number of rows with the same set of data values (see the left figure below). To ensure that each data row is drawn as a glyph in Charticulator, you need to tell Power BI not to summarize, by selecting the Don’t summarize menu item.

Do not summarize

Data Order​

By default, Charticulator does not sort data and handles the data in the order they appear in the table. On the other hand, Power BI usually tries to order data in a predefined way (based on data values). Therefore, if you want to enforce an order that is not based on existing data values, you need to add a data field to specify order and then order the table based on that field.

Data order

Date vs. Date Hierarchy​

For the date type data value (e.g., "02/24/2021"), Charticulator automatically extracts its subcomponents (e.g., day, dayOfYear, weekday). On the other hand, Power BI creates a date hierarchy, consisting of Year, Quarter, Month, and Day, and uses the date hierarchy by default. Therefore, to reuse a chart design created with Charticulator in Power BI, you need to select the Date menu item.

Date

Original documentation source

To draw a chart with the links between glyphs in Charticulator, you need two data tables: one for nodes (or entities) and another for links (or relationships) between nodes. Because Power BI visuals expects a single table, you need to create a relationship between these two tables, by following these steps:

  1. Select Modeling from the main menu.
  2. Select Manage relationships from the ribbon.
  3. In the Manage relationships window, select New….
  4. In the Create relationship window, follow these steps:
    1. Select the table for nodes from the first dropdown menu.
    2. Select the table for links from the second dropdown menu.
    3. Select the id column from the table for nodes.
    4. Select the source_id column from the table for links.
    5. Select Many to many (.) from the Cardinality dropdown.
    6. Select OK to compete the relationship creation process.

Create relationship

After creating the relationship, do not forget to select both Don’t summarize and Show items with no data for all columns in the Data and Links sections.