Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |