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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Charu
Post Patron
Post Patron

bottom Subtitle in power bi service dashboard

Hi Everyone,

 

Could anyone tell me how to add some text to the bottom of KPI visual in power bi service dashboard?

For your reference please look at the below image

 

tile title.PNG 

1 ACCEPTED SOLUTION

Hi @Charu,

 

1. The function "Format" would help.

Title =
"Booked to date VS " & " "
    & FORMAT ( VALUE ( MIN ( 'Tablename'[CAT Avg] ) ), "0.000" )
    & " K Goal"

2. I afraid we can't add it directly. How about adding a card visual like below.

bottom_Subtitle_in_power_bi_service_dashboard

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Charu
Post Patron
Post Patron

Hi Everyone,

I have create following measure to concatenate Text and value as below

Title = "Booked to date VS " &" " & VALUE('Tablename'[CAT Avg] ) & "K Goal"

1. I couldn't  reduce the decimal place value

title measure.PNG

2. how to display this measure in the visual that I already attached.

 

Need help as soon as possible ...

Hi @Charu,

 

1. The function "Format" would help.

Title =
"Booked to date VS " & " "
    & FORMAT ( VALUE ( MIN ( 'Tablename'[CAT Avg] ) ), "0.000" )
    & " K Goal"

2. I afraid we can't add it directly. How about adding a card visual like below.

bottom_Subtitle_in_power_bi_service_dashboard

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-jiascu-msft

Thanks for your help.

whether any custom visual you know to achieve like in the sample image I have attcahed? 

Hi @Charu,

 

The similar visual I can find is the card. Change some settings.

bottom_Subtitle_in_power_bi_service_dashboard2

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-jiascu-msft

so you are saying, these are the only possibilities?

 

If you see another tile its has Target goal value whether that too hardcoded?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors