{"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":"prekryvajici-se-text-pro-matrici-heatmap-rizika-power-bi","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/cs\/prekryvajici-se-text-pro-matrici-heatmap-rizika-power-bi\/","title":{"rendered":"P\u0159ekr\u00fdvaj\u00edc\u00ed se text"},"content":{"rendered":"

Texty rizik jsou dlouh\u00e9 a ve vizualizaci se p\u0159ekr\u00fdvaj\u00ed? Shrom\u00e1\u017edili jsme pro v\u00e1s n\u011bkolik \u0159e\u0161en\u00ed.<\/p>\n\n\n\n

Omezen\u00ed po\u010dtu znak\u016f<\/h3>\n\n\n\n

D\u00e1le je mo\u017en\u00e9 omezit po\u010det znak\u016f v dimenzi nebo sloupci. To umo\u017e\u0148uje individu\u00e1ln\u011b definovat d\u00e9lku \u0159et\u011bzce tak, aby bylo riziko st\u00e1le \u010diteln\u00e9.<\/p>\n\n\n\n

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

Zde jsme omezili popis rizika na prvn\u00edch osm znak\u016f a pot\u00e9 p\u0159idali t\u0159i te\u010dky pro lep\u0161\u00ed \u010ditelnost. Podrobn\u00fd popis m\u016f\u017eete st\u00e1le zobrazit po najet\u00ed my\u0161\u00ed.<\/p>\n<\/div>\n<\/div>\n\n\n\n

\n
\n

Za t\u00edmto \u00fa\u010delem nejprve klikneme na kartu \"Modelov\u00e1n\u00ed\" v aplikaci Power BI a pot\u00e9 na \"Nov\u00fd sloupec\".<\/p>\n\n\n\n

Otev\u0159e se editor DAX.<\/p>\n<\/div>\n\n\n\n

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

V na\u0161em p\u0159\u00edkladu obsahuje sloupec \"Dlouh\u00fd popis\" text, kter\u00fd chceme zkr\u00e1tit. K\u00f3d je t\u0159eba odpov\u00eddaj\u00edc\u00edm zp\u016fsobem upravit podle jeho popisu. Zde nyn\u00ed do tohoto p\u0159\u00edkladu vlo\u017e\u00edme n\u00e1sleduj\u00edc\u00ed k\u00f3d:<\/p>\n\n\n\n

Description Short = CONCATENATE(LEFT([Description Long], 8),\"...\")<\/code><\/pre>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
Vnit\u0159n\u00ed funkce LEFT zkr\u00e1t\u00ed rozm\u011br na prvn\u00edch osm p\u00edsmen od za\u010d\u00e1tku. Funkc\u00ed CONCATENATE se zkr\u00e1cen\u00fd \u0159et\u011bzec a t\u0159\u00edbodov\u00fd \u0159et\u011bzec \"...\" spoj\u00ed.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
Nyn\u00ed pou\u017eijeme sloupec \"Kr\u00e1tk\u00fd popis\" a p\u0159i\u0159ad\u00edme jej poli \"ID rizika\" vizualizace.<\/p>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
Pou\u017eit\u00ed vnit\u0159n\u00edho ID rizika syst\u00e9mu<\/h3>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
P\u0159edpokl\u00e1dejme, \u017ee jste do pole \"ID rizika\" na\u010detli sv\u00e1 rizika. Nyn\u00ed se texty p\u0159ekr\u00fdvaj\u00ed. Prvn\u00ed mo\u017enost\u00ed je pou\u017e\u00edt intern\u00ed ID - pokud je to mo\u017en\u00e9 - syst\u00e9mov\u00e9ho rizika m\u00edsto del\u0161\u00edho popisu rizika. Ten m\u00e1 \u010dasto m\u00e9n\u011b znak\u016f.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
M\u00edsto del\u0161\u00edho popisu se zde pou\u017e\u00edv\u00e1 ID. T\u00edm se sn\u00ed\u017e\u00ed po\u010det znak\u016f a je to p\u0159ehledn\u011bj\u0161\u00ed. Popis rizika lze nyn\u00ed zobrazit najet\u00edm my\u0161\u00ed 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
Za t\u00edmto \u00fa\u010delem p\u0159esu\u0148te sloupec nebo dimenzi s del\u0161\u00edm textem do pole \"Tooltip (voliteln\u00e9)\" a identifik\u00e1tor rizika ze syst\u00e9mu do pole \"Risk ID\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
Minimalizace po\u010dtu zobrazen\u00fdch rizik na dla\u017edici<\/h3>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
Dal\u0161\u00ed mo\u017enost\u00ed je minimalizovat po\u010det zobrazen\u00fdch rizik. P\u016fvodn\u011b jsme tuto mo\u017enost zavedli, abychom u\u017eivateli umo\u017enili sn\u00ed\u017eit po\u010det rizik na dla\u017edici. Cokoli nad tento po\u010det se zobraz\u00ed jako sou\u010det rizik s koso\u010dtvercem vp\u0159edu.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
V tomto p\u0159\u00edkladu jsme nastavili po\u010det zobrazen\u00fdch rizik na hodnotu 1. Pokud je zde tedy dla\u017edici p\u0159i\u0159azeno v\u00edce ne\u017e jedno riziko, vytvo\u0159\u00ed se sou\u010det, kter\u00fd se zobraz\u00ed.<\/p>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"
Texty rizik jsou dlouh\u00e9 a ve vizualizaci se p\u0159ekr\u00fdvaj\u00ed? Shrom\u00e1\u017edili jsme pro v\u00e1s n\u011bkolik \u0159e\u0161en\u00ed. Omezen\u00ed po\u010dtu znak\u016f D\u00e1le je mo\u017en\u00e9 omezit po\u010det znak\u016f v dimenzi nebo sloupci. To v\u00e1m umo\u017en\u00ed individu\u00e1ln\u011b definovat d\u00e9lku \u0159et\u011bzce tak, aby se rizika ... <\/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\/cs\/wp-json\/wp\/v2\/pages\/9141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/comments?post=9141"}],"version-history":[{"count":0,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/9141\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/media?parent=9141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}