Do you want to know what the visual can do? Or interested in licenses?
See Regression Chart Product page.
See our help videos on Youtube.
You need at least two numerical variables, add them to dataroles X and Y. Select “Don’t Summarize” for the dataroles.
You can add additional grouping variables, Subgroup, and Facet. You can also add Tooltip texts if needed.
PowerBI framework loves to aggregate data. This means that duplicate values are transferred to visual only once. Usually, this is the right thing to do, as many times it doesn’t make a difference for visualization. Aggregating data has a positive effect on performance.
But sometimes you really need all the data. Think about calculating the regression line. It really does make a difference whether you use all the data or just the unique values.
That’s why there are two possible ways to add the x and y variables to the visual in Regression Chart.
1) Without UniqueID
Use UniqueID when you to know that all of the data is unique, or you just want to visualize datapoint, and you don’t need the regression line.
To go without UniqueID, add your data fields to visual’s dataroles. Make sure you have selected “Don’t summarize” for both of the variables.
2) With UniqueID
Use this if you want to use regression line and you want to make sure the results are correct.
If you don’t have an index or a row id column in your fact table, you easily create one in Power BI Desktop. Go to Edit queries > Add column > Index column, and select “Index from 1”. It will create ‘Index’ named column, add this to the visual’s UniqueID datarole.
How to check if visual uses all of my data?
You can do it by comparing the row count from the Data tab to the visual’s ‘n’.
Create a visual, fix the needed settings and add the license key. Copy this visual when creating actual visualization. For the copies, you don’t need to add license key separately. You can even create an additional page to the report and place the original visual there. Remove the extra page when the report is ready.
See the help video on how to enter the license key, and how to copy the visual, so you don’t have to enter the key again.
If you have a larger data set than a few thousand items, you will be better off using Power BI Desktop or Chrome browser. You will not get the best performance using Internet Explorer or Edge browsers.
You should also make sure that you have selected the ‘Render > Speed’ option from the settings. When selecting this, please make sure that your chart renders correctly before publishing it, as it may have problems with older browsers.
The responsiveness of the Regression Chart makes the Power BI framework sometimes think that we have already finished drawing when we actually have not. If this causes problems to you, select “Render > Export to PDF”. This will make the Regression Chart behave as unresponsive as regular visuals.
There are two ways to get the visual:
1) AppSource website
You can download the visual file and example report from the AppSource website. After downloading the visual file, select “Import from file” in Power BI desktop and select the downloaded file.
2) Import directly to report
Use the Power BI’s “Import from Marketplace” feature and add the visual directly to your report.
We are more than happy to hear from you. Send mail to support (at-the) craydec.com.
1.1.1 / 7.3.2019
- Fix: visual froze on certain datasets.
- Fix: speed render draw data-area wrong on certain browsers.
- Fix: ‘No Data’ page shown when data was aggregated to one data point.
1.0.1 / 19.2.2019