cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors