{"id":9141,"date":"2022-07-21T14:51:23","date_gmt":"2022-07-21T12:51:23","guid":{"rendered":"https:\/\/www.leaplytics.de\/?page_id=9141"},"modified":"2022-07-21T14:51:24","modified_gmt":"2022-07-21T12:51:24","slug":"overlappende-tekst-for-risikomatrise-for-varmekart-power-bi","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/nb\/overlappende-tekst-for-risikomatrise-for-varmekart-power-bi\/","title":{"rendered":"Overlappende tekst"},"content":{"rendered":"<p>Er tekstene til risikoene lange og overlapper hverandre i visualiseringen? Vi har samlet noen l\u00f8sninger for deg.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Begrensning av antall tegn<\/h3>\n\n\n\n<p>Det er ogs\u00e5 mulig \u00e5 begrense antall tegn i en dimensjon eller kolonne. P\u00e5 denne m\u00e5ten kan du definere lengden p\u00e5 strengen individuelt, slik at risikoen fortsatt er lesbar.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"446\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-8.png\" alt=\"\" class=\"wp-image-9159\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-8.png 604w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-8-300x222.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-8-570x420.png 570w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-8-81x60.png 81w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Her har vi begrenset beskrivelsen av risikoen til de f\u00f8rste \u00e5tte tegnene og deretter lagt til tre prikker for bedre lesbarhet. Du kan fortsatt se den detaljerte beskrivelsen ved \u00e5 holde musepekeren over.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-2 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>For \u00e5 gj\u00f8re dette klikker vi f\u00f8rst p\u00e5 \"Modeling\"-fanen i Power BI og deretter p\u00e5 \"New Column\".<\/p>\n\n\n\n<p>DAX Editor \u00e5pnes.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"616\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-9.png\" alt=\"\" class=\"wp-image-9160\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-9.png 709w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-9-300x261.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-9-69x60.png 69w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p>I v\u00e5rt eksempel inneholder kolonnen \"Description Long\" teksten vi \u00f8nsker \u00e5 forkorte. Du m\u00e5 justere koden i henhold til beskrivelsen. Her setter vi n\u00e5 inn f\u00f8lgende kode i dette eksemplet:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Beskrivelse kort = CONCATENATE(LEFT([Beskrivelse lang], 8),\"...\")<\/code><\/pre>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-3 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"634\" height=\"459\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-10.png\" alt=\"\" class=\"wp-image-9161\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-10.png 634w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-10-300x217.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-10-83x60.png 83w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Den indre funksjonen LEFT trunkerer dimensjonen til de f\u00f8rste \u00e5tte bokstavene fra begynnelsen. Ved hjelp av funksjonen CONCATENATE kobles den forkortede strengen og trepunktet '...' sammen.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-4 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Vi bruker n\u00e5 kolonnen \"Kort beskrivelse\" og tilordner den til feltet \"Risiko-ID\" i visualiseringen.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"639\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-11.png\" alt=\"\" class=\"wp-image-9162\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-11.png 560w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-11-263x300.png 263w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-11-53x60.png 53w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Bruk av systemets interne risiko-ID<\/h3>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-5 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"510\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-1.png\" alt=\"\" class=\"wp-image-9145\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-1.png 701w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-1-300x218.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-1-82x60.png 82w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>La oss anta at du har lagt inn risikoene dine i \"Risk ID\"-feltet. N\u00e5 overlapper tekstene hverandre. En f\u00f8rste mulighet er \u00e5 bruke en intern ID - hvis mulig - for systemets risiko i stedet for den lengre beskrivelsen av risikoen. Denne har ofte f\u00e6rre tegn.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-6 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>I stedet for den lengre beskrivelsen brukes ID-en her. Dette reduserer antall tegn og gj\u00f8r det tydeligere. Beskrivelsen av risikoen kan n\u00e5 vises ved \u00e5 holde musepekeren over boblen.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"684\" height=\"519\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-3.png\" alt=\"\" class=\"wp-image-9147\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-3.png 684w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-3-300x228.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-3-370x280.png 370w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-3-79x60.png 79w\" sizes=\"auto, (max-width: 684px) 100vw, 684px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:50%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"562\" height=\"616\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-5.png\" alt=\"\" class=\"wp-image-9154\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-5.png 562w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-5-274x300.png 274w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-5-55x60.png 55w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Dette gj\u00f8r du ved \u00e5 flytte kolonnen eller dimensjonen med den lengre teksten til feltet \"Tooltip (valgfritt)\" og risikoidentifikatoren fra systemet til feltet \"Risk ID\".<\/p>\n<\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Minimer antall viste risikoer per brikke<\/h3>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"512\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-6.png\" alt=\"\" class=\"wp-image-9157\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-6.png 708w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-6-300x217.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-6-83x60.png 83w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Et annet alternativ er \u00e5 minimere antallet risikoer som vises. Vi implementerte opprinnelig dette for \u00e5 gj\u00f8re det mulig for brukeren \u00e5 senke antallet risikoer per brikke. Alt over dette vil vises som en sum av risikoer med en diamant foran.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>I dette eksempelet har vi satt antall viste risikoer til verdien 1. S\u00e5 hvis mer enn \u00e9n risiko er tilordnet flisen her, blir det dannet en sum som vises.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"615\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-7.png\" alt=\"\" class=\"wp-image-9158\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-7.png 559w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-7-273x300.png 273w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/07\/grafik-7-55x60.png 55w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><\/figure>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Er tekstene til risikoene lange og overlapper hverandre i visualiseringen? Vi har samlet noen l\u00f8sninger for deg. Begrensning av antall tegn Videre er det mulig \u00e5 begrense antall tegn i en dimensjon eller kolonne. Dette gj\u00f8r at du kan definere lengden p\u00e5 strengen individuelt, slik at risikoen ... <\/p>","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-9141","page","type-page","status-publish","hentry","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/nb\/wp-json\/wp\/v2\/pages\/9141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/nb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/nb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/nb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/nb\/wp-json\/wp\/v2\/comments?post=9141"}],"version-history":[{"count":0,"href":"https:\/\/www.leaplytics.de\/nb\/wp-json\/wp\/v2\/pages\/9141\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/nb\/wp-json\/wp\/v2\/media?parent=9141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}