{"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":"prekryvajuci-sa-text-pre-maticu-heatmap-rizika-power-bi","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/sk\/prekryvajuci-sa-text-pre-maticu-heatmap-rizika-power-bi\/","title":{"rendered":"Prekr\u00fdvaj\u00faci sa text"},"content":{"rendered":"

Texty riz\u00edk s\u00fa dlh\u00e9 a vo vizualiz\u00e1cii sa prekr\u00fdvaj\u00fa? Zozbierali sme pre v\u00e1s nieko\u013eko rie\u0161en\u00ed.<\/p>\n\n\n\n

Obmedzenie po\u010dtu znakov<\/h3>\n\n\n\n

Okrem toho je mo\u017en\u00e9 obmedzi\u0165 po\u010det znakov v dimenzii alebo st\u013apci. To umo\u017e\u0148uje individu\u00e1lne definova\u0165 d\u013a\u017eku re\u0165azca tak, aby bolo riziko st\u00e1le \u010ditate\u013en\u00e9.<\/p>\n\n\n\n

\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Tu sme obmedzili opis rizika na prv\u00fdch osem znakov a potom sme pridali tri bodky pre lep\u0161iu \u010ditate\u013enos\u0165. Podrobn\u00fd opis si st\u00e1le m\u00f4\u017eete pozrie\u0165 po prejden\u00ed my\u0161ou.<\/p>\n<\/div>\n<\/div>\n\n\n\n

\n
\n

Ak to chcete urobi\u0165, najprv kliknite na kartu \"Modelovanie\" v aplik\u00e1cii Power BI a potom kliknite na polo\u017eku \"Nov\u00fd st\u013apec\".<\/p>\n\n\n\n

Otvor\u00ed sa editor DAX.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n

V na\u0161om pr\u00edklade obsahuje st\u013apec \"Popis dlh\u00fd\" text, ktor\u00fd chceme skr\u00e1ti\u0165. K\u00f3d mus\u00edte zodpovedaj\u00facim sp\u00f4sobom upravi\u0165 pod\u013ea jeho popisu. Tu teraz vlo\u017e\u00edme nasleduj\u00faci k\u00f3d v tomto pr\u00edklade:<\/p>\n\n\n\n

Popis Short = CONCATENATE(LEFT([Popis Long], 8),\"...\")<\/code><\/pre>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
Vn\u00fatorn\u00e1 funkcia LEFT skr\u00e1ti rozmer na prv\u00fdch osem p\u00edsmen od za\u010diatku. Funkciou CONCATENATE sa spoj\u00ed skr\u00e1ten\u00fd re\u0165azec a trojbodka \"...\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
Teraz pou\u017eijeme st\u013apec \"Kr\u00e1tky popis\" a prirad\u00edme ho k po\u013eu \"ID rizika\" vizualiz\u00e1cie.<\/p>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
Pou\u017e\u00edvanie vn\u00fatorn\u00e9ho identifik\u00e1tora rizika syst\u00e9mu<\/h3>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
Predpokladajme, \u017ee ste do po\u013ea \"ID rizika\" vlo\u017eili svoje rizik\u00e1. Teraz sa texty prekr\u00fdvaj\u00fa. Prvou mo\u017enos\u0165ou je pou\u017ei\u0165 intern\u00e9 ID - ak je to mo\u017en\u00e9 - syst\u00e9mov\u00e9ho rizika namiesto dlh\u0161ieho opisu rizika. Ten m\u00e1 \u010dasto menej znakov.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
Namiesto dlh\u0161ieho popisu sa tu pou\u017e\u00edva ID. T\u00fdm sa zn\u00ed\u017ei po\u010det znakov a je to preh\u013eadnej\u0161ie. Popis rizika sa teraz m\u00f4\u017ee zobrazi\u0165 po nabehnut\u00ed my\u0161ou na bublinu.<\/p>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
Ak to chcete urobi\u0165, presu\u0148te st\u013apec alebo rozmer s dlh\u0161\u00edm textom do po\u013ea \"Tooltip (volite\u013en\u00e9)\" a identifik\u00e1tor rizika zo syst\u00e9mu do po\u013ea \"Risk ID\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
Minimaliz\u00e1cia po\u010dtu zobrazen\u00fdch riz\u00edk na dla\u017edicu<\/h3>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\u010eal\u0161ou mo\u017enos\u0165ou by bolo minimalizova\u0165 po\u010det zobrazen\u00fdch riz\u00edk. P\u00f4vodne sme to zaviedli, aby sme pou\u017e\u00edvate\u013eovi umo\u017enili zn\u00ed\u017ei\u0165 po\u010det riz\u00edk na dla\u017edicu. V\u0161etko, \u010do je vy\u0161\u0161ie, sa zobraz\u00ed ako s\u00fa\u010det riz\u00edk s diamantom vpredu.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
V tomto pr\u00edklade sme nastavili po\u010det zobrazen\u00fdch riz\u00edk na hodnotu 1. Ak je tu teda k dla\u017edici priraden\u00e9 viac ako jedno riziko, vytvor\u00ed sa s\u00fa\u010det a zobraz\u00ed sa.<\/p>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"
Texty riz\u00edk s\u00fa dlh\u00e9 a vo vizualiz\u00e1cii sa prekr\u00fdvaj\u00fa? Zozbierali sme pre v\u00e1s nieko\u013eko rie\u0161en\u00ed. Obmedzenie po\u010dtu znakov Okrem toho je mo\u017en\u00e9 obmedzi\u0165 po\u010det znakov v dimenzii alebo st\u013apci. To v\u00e1m umo\u017en\u00ed individu\u00e1lne definova\u0165 d\u013a\u017eku re\u0165azca tak, aby sa rizik\u00e1 ... <\/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\/sk\/wp-json\/wp\/v2\/pages\/9141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/comments?post=9141"}],"version-history":[{"count":0,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/9141\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/media?parent=9141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}