This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Hello,
I'm using pbiviz to do some custom R HTML visuals. With capabilities.json, I'm able to control the dataset(s) exported from Power BI to the the R script (their names and their display names). But is it possible to export say a string to use as a title of the graphic? (for example if I use ggplot with ggtitle followed by ggploty). I mean a string that the user is able to choose.
Solved! Go to Solution.
I managed to add a text input for setting a title and a dropdown list for setting a chart theme:
This is achieved by modifying two files: the file capabilities.json and the file src/settings.ts in the folder created by pbiviz.
Here is the file capabilities.json. I modified the objects node:
And here is the TypeScript file src/settings.ts:
Then, in the file script.r, the title set by the user and the theme he chooses are named ggsettings_ChartTitle and ggsettings_ChartTheme respectively. But they won't be available at the first creation of the chart, so we have to check for their existence in the R script. Here is the full script I used:
I managed to add a text input for setting a title and a dropdown list for setting a chart theme:
This is achieved by modifying two files: the file capabilities.json and the file src/settings.ts in the folder created by pbiviz.
Here is the file capabilities.json. I modified the objects node:
And here is the TypeScript file src/settings.ts:
Then, in the file script.r, the title set by the user and the theme he chooses are named ggsettings_ChartTitle and ggsettings_ChartTheme respectively. But they won't be available at the first creation of the chart, so we have to check for their existence in the R script. Here is the full script I used:
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Check out the July 2026 Power BI update to learn about new features.