Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Change format in mesure in tooltip

Hello i have that kind of measure for my tooltip 
 
And i wloud like  to show sentence with "udziaล‚" in % 
And rest of them as number 
like this
Kompletacja udziaล‚ godzin 23%
Kompl. (jedn. wyd./h) 123,43
 
 
 
Wartoล›ฤ‡ tool tip = CALCULATE(SUM(Dane_agr[wartosc_val]),Nazwy_OP[Nazwa_PBI] in
{"Kompletacja udziaล‚ godzin",
"Operatorzy udziaล‚ godzin",
"Zaล‚adunek udziaล‚ godzin",
"Przyjฤ™cia udziaล‚ godzin",
"Kompl. (jedn. wyd./h)",
"Operatorzy g/d",
"Przyjฤ™cia (pal/h )",
"Zaล‚adunek ( pal/h )"})
 
I think i should use something with contains and format but i dont know how to change it 
4 REPLIES 4
tamerj1
Super User
Super User

Hi @Anonymous 
Please try

Wartoล›ฤ‡ tool tip =
VAR Result =
    CALCULATE (
        SUM ( Dane_agr[wartosc_val] ),
        Nazwy_OP[Nazwa_PBI]
            IN {
            "Kompletacja udziaล‚ godzin",
            "Operatorzy udziaล‚ godzin",
            "Zaล‚adunek udziaล‚ godzin",
            "Przyjฤ™cia udziaล‚ godzin",
            "Kompl. (jedn. wyd./h)",
            "Operatorzy g/d",
            "Przyjฤ™cia (pal/h )",
            "Zaล‚adunek ( pal/h )"
        }
    )
RETURN
    IF (
        CONTAINSSTRING ( SELECTEDVALUE ( Nazwy_OP[Nazwa_PBI] ), "udziaล‚" ),
        FORMAT ( Result, "Percent" ),
        Result
    )
Anonymous
Not applicable

Thank you a lot i dont see any error 

 

but still don't see %

 

haron89_0-1670333483567.png

 

@Anonymous 
Make sure you are using the correct column inside SELECTEDVALUE

Anonymous
Not applicable

VARb =

VAR WYLICZENIA = CALCULATE (

SUM ( Dane_agr[wartosc_val] ),

Nazwy_OP[Nazwa_PBI]

IN {

"Kompletacja udziaล‚ godzin",

"Operatorzy udziaล‚ godzin",

"Zaล‚adunek udziaล‚ godzin",

"Przyjฤ™cia udziaล‚ godzin","Kompl. (jedn. wyd./h)",

"Operatorzy g/d",

"Przyjฤ™cia (pal/h )",

"Zaล‚adunek ( pal/h )"

}

)

VAR FORMATOWANIE = IF (Calculate(WYLICZENIA)<1,FORMAT(WYLICZENIA, "Percent"),WYLICZENIA)

RETURN

FORMATOWANIE
 
 
 
that is working now but still helpfull. 

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (25)