Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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:
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
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
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
Hi @v-yulgu-msft,
Good news in the meantime. I used the example you have provided to activate data labels sucessfully. Thanks.
Now I am able to turn of the data labels for all visuals or for selected visuals only.
Example for all visuals:
{ "name": "DataLabels4All", "dataColors": ["#FA3C78", "#3C32DC", "#8996FF", "#000175", "#6B008A"], "background":"#FFFFFF", "foreground": "#3C32DC", "tableAccent": "#FA3C78", "visualStyles":{ "*":{ "*":{ "*":[{ "responsive":true, "wordWrap":true, "fontSize":14, "fontFamily":"Arial" }], "wordWrap":[{ "show":true }], "labels":[{ "show":true, "labelOrientation":"horizontal", "fontSize":9, "labelDensity":77 }], "categoryLabels":[{ "show":true }], "categoryAxis":[{ "showAxisTitle":true }], "valueAxis":[{ "showAxisTitle":true }] } } } }
And here me example to enbale data labels for line charts only:
{ "name": "DataLabelsLineCharts", "dataColors": ["#FA3C78", "#3C32DC", "#8996FF", "#000175", "#6B008A"], "background":"#FFFFFF", "foreground": "#3C32DC", "tableAccent": "#FA3C78", "visualStyles":{ "*":{ "*":{ "*":[{ "responsive":true, "wordWrap":true, "fontSize":14, "fontFamily":"Arial" }], "wordWrap":[{ "show":true }], "categoryLabels":[{ "show":true }], "categoryAxis":[{ "showAxisTitle":true }], "valueAxis":[{ "showAxisTitle":true }] } }, "lineChart":{ "*":{ "labels":[{ "show":true, "labelOrientation":"horizontal", "fontSize":9, "labelDensity":77 }] } } } }
Another questions what are "categoryLabels" for? About what categories are we talking and under which card can I find it?
Thank you.
Cheers,
Dom
Short followup... I found the purpose of "categoryLabels". Those labels are used for ither visual types such as "Card". There you are able to activate the format option "Category label".
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.
https://powerbi.tips/tools/report-theme-generator-v3/
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |