Forum Discussion

Ariful's avatar
Ariful
Frequent Visitor
1 year ago
Solved

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.
  • 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.

3 Replies

  • 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".

    • Ariful's avatar
      Ariful
      Frequent Visitor

      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?

  • Ariful's avatar
    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.