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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Ariful
Frequent Visitor

How I can display text value in Display Measure section in Mekko Chart ( Custom Visual)

I have desing a simple Mekko Chart using custom visual (Marimekko Chart - xViz)

, just I want to add the text "hrs" after my hours value , I am trying several time but not getting success , please help me, someone already done it( I am attaching a picture FYI), I have used  the following 

ff = FORMAT(AVERAGE('DataTable'[Time_Spent]), "0.0")&"hrs"  FORMAT function, 
N.B: Display Measure section in Mekko Chart not accept  text value.Mekko Chart.png
1 ACCEPTED SOLUTION
Ariful
Frequent Visitor

There is a option in Marimekko Chart name as Suffix, I have just put "hrs" and it is showing on measure sections withour writing any measures.

View solution in original post

3 REPLIES 3
Ariful
Frequent Visitor

There is a option in Marimekko Chart name as Suffix, I have just put "hrs" and it is showing on measure sections withour writing any measures.

bhanu_gautam
Super User
Super User

@Ariful If the chart does not accept text values directly, you can use a tooltip to display the formatted text. Create a measure for the tooltip:

AverageTimeSpentWithText = FORMAT(AVERAGE('DataTable'[Time_Spent]), "0.0") & " hrs"

 

Add the AverageTimeSpentWithText measure to the tooltip section of the Mekko Chart. This way, when you hover over the data points, it will display the formatted text with "hrs".




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Thank you for your kind reply, but the requirements is instead of tooltip need to directly show on chart like my attached picture,  how they ( others person) have done it?

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors