Forum Discussion
Report Themes - Enable further format options via JSON
Hi,
I'm looking for a possility to creat a template theme I can use for reports.
To preconfigure colors is not an issue. But how can I enable further format options such as "Data labels".
It seems to me that the list of options on https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-themes/ is not complete in order to configure all possible format options.
Do you have any experience so far or hints reagrding this issue?
Thanks a lot.
Dom
Hi Anonymous,
Please download the sample JSON file here. You can import the theme file into your pbix file to see whether it works. Also, you can open the json file as a reference, to see how to correctly set data labels for chart visual.
Best regards,
Yuliana Gu
6 Replies
- v-yulgu-msft
Microsoft Employee
Hi Anonymous,
Since Power BI desktop September update, more theme file format was added to include full control over your chart styling.
This means you can do things like:
- Set all your charts to use size 14 font
- Set your matrix values to use Calibri font
- Turn data labels on for specific charts
Reference: Theming preview update – chart style controls
If you want more format options which are not supported now, you could submit it at idea page.
Best regards,
Yuliana Gu- AnonymousNot applicable
Hi v-yulgu-msft,
That was the information I was looking for. So far I only checked the documentation on https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-themes/ but I overlooked the information of the link you have provided. Thanks.
Anyway, I'm still unable to actiate the format option "Data labels":
My JSON file looks like this at the moment:
{ "name": "BringItOn", "dataColors": [ "#6876ff", "#a9d1f4", "#63bb80", "#783b3c", "#000831", "#141256", "#d0d0d7" ], "background": "#f2f2f3", "foreground": "#575760", "tableAccent": "#aba9f4", "visualStyles":{ "*":{ "*":{ "*":[{ "fontSize":14, "fontFamily":"Arial", "dataLabels": [{ "show": true }], "axisType": [{ "value": "Categorical", "displayName": "Categorical" }] }] } } } }I also tried the cardName"labels", which is refering to "Data labels" according to the documentation on https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-themes/.
Any ideas?
Cheers,
Dom
- v-yulgu-msft
Microsoft Employee
Hi Anonymous,
Please download the sample JSON file here. You can import the theme file into your pbix file to see whether it works. Also, you can open the json file as a reference, to see how to correctly set data labels for chart visual.
Best regards,
Yuliana Gu
- PowerDAX
Resolver III
Hi Dom - they are indeed still adding theme options.
Here is a great link to assist in building the JSON required - Michael is adding theme options to the generator as they become available.