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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors