How can I get text and value in a stacked bar chart ?

[EaglesTony]

Hi,

  I have a stacked bar chart and on the X-axis I have a column "TotalCountDone", which I show the Maximize value.

  This is working and showing the number 32.

  What I want to do is to show this in the bar chart as "32(Done)", how can I combine Text to the number and display it like this ?

[Anonymous · Accepted solution]

Hi @EaglesTony 

Try creating a measure to dynamically generate data labels like this:

Detail = 
VAR DoneValue = SUMX(FILTER('DataTable', 'DataTable'[SubCategory] = "Done"), 'DataTable'[Values])
VAR BacklogValue = SUMX(FILTER('DataTable', 'DataTable'[SubCategory] = "Backlog"), 'DataTable'[Values])
RETURN 
IF(
    HASONEVALUE('DataTable'[SubCategory]),
    SWITCH(
        VALUES('DataTable'[SubCategory]),
        "Done", DoneValue & " (Done)",
        "Backlog", BacklogValue & " (Backlog)"
    ),
    BLANK()
)

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[EaglesTony]

Thanks this worked!

[EaglesTony]

What I need is to display within the bar 3(Done). I think I had this before, but not sure how it changed.

[suparnababu8]

Hi @EaglesTony 

Create a calculated column with below DAX

CombinedText = FORMAT(MAX('Table'[TotalCountDone]), "0") & "(Done)"

The use this in x-axis of your bar chart. Then it'll display 32(Done)

Hope this helps

Thanks!

[EaglesTony]

I put it on the X-axis, but it is just showing me the number, as the option to display it has Count.

Here is what I have:

[Kaviraj11]

Can you update your Power BI version to the latest version? 

[EaglesTony]

Sure.

I have a column called "TotalDone", so I would create a measure as follows ?

TotalDoneDisplay = [field from table with the actual number] + "(Done)" ?

[Kaviraj11]

You could do this - CONCATENATE(SUM('Table'[ColumnName]),"(Done)")

[EaglesTony]

I was able to use:

DoneDisplay = CONVERT(FeaturesWithTheirIssues[TotChildCountDone],STRING) & "(Done)"

However, My bar is now showing inside

32 32(Done)

How can I get rid of the first 32 displaying as I just want

32(Done)

I have multiple statuses as well not just Done, so I am thinking I need to do the same thing for the other ones ?

[Kaviraj11]

Turn off the value section

Yes, you will need to create a condition, you can use SWITCH function.

[EaglesTony]

I need to show Backlog and Done, the following in Red is the Backlog(even though it shows Done", the purple is the actual Done.

What I need is to show both of these in that bar as such:

Red would be "3(Backlog)" and Purple would be "32(Done)

[EaglesTony]

Any ideas on this ?

[Kaviraj11]

Hi,

You can do it this way- Create a calculated column with the defintion you have and then put it in Detail sub section under data labels.

[EaglesTony]

I don't see that.

Under Data Labels I have: