{"id":9192,"date":"2022-10-20T14:42:22","date_gmt":"2022-10-20T12:42:22","guid":{"rendered":"https:\/\/via-internet.de\/blog\/?p=9192"},"modified":"2023-11-05T16:33:27","modified_gmt":"2023-11-05T15:33:27","slug":"power-bi-visuals-cookbook","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2022\/10\/20\/power-bi-visuals-cookbook\/","title":{"rendered":"Power BI Visuals | Cookbook"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Installation<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Install NodeJS<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">Install pbiviz<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">npm i -g powerbi-visuals-tools@latest<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Calculating of Data<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Working with Highlighted values (&#8220;supportsHighlight&#8221;: true)<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">sumOfValues     = Object.keys(node.values).map(key => +node.values[key].value).reduce((prev, curr) => prev + curr)\nsumOfHighlights = Object.keys(node.values).map(key => node.values[key].highlight ? +node.values[key].highlight : null).reduce((prev, curr) => curr ? prev + curr : null)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Get all Level Names<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">matrix.rows.levels.map( l => l.sources[0].displayName).join('\/')<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Table Tooltips<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Im Repository TableSorter<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"283\" src=\"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2022\/07\/image.png\" alt=\"\" class=\"wp-image-9193\" srcset=\"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2022\/07\/image.png 798w, https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2022\/07\/image-300x106.png 300w, https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2022\/07\/image-768x272.png 768w\" sizes=\"auto, (max-width: 798px) 100vw, 798px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Useful functions<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Calculate Average of Data Points<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">private calculateAverage(): number {\n\tif (this.dataPoints.length === 0) {\n\t\treturn 0;\n\t}\n\n\tlet total = 0;\n\tthis.dataPoints.forEach((value: ICustomDataPoint) => {\n\t\ttotal += &lt;number>value.value;\n\t});\n\n\treturn total \/ this.dataPoints.length;\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">capabilities.json<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Alignment<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">        \"alignment\": {\n          \"type\": {\n            \"formatting\": {\n              \"alignment\": true\n            }\n          },\n          \"displayName\": \"Horizontal Alignment\"\n        },<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Installation Install NodeJS Install pbiviz Calculating of Data Working with Highlighted values (&#8220;supportsHighlight&#8221;: true) Get all Level Names Table Tooltips Im Repository TableSorter Useful functions Calculate Average of Data Points capabilities.json Alignment<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[59,146],"tags":[],"class_list":["post-9192","post","type-post","status-publish","format-standard","hentry","category-power-bi","category-power-bi-visuals"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=9192"}],"version-history":[{"count":7,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9192\/revisions"}],"predecessor-version":[{"id":9739,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9192\/revisions\/9739"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=9192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=9192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=9192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}