Showing % in Sankey diagram

[Saniat]

Hi, in the PBI native sankey diagram (which we can download and use for free) is there a way to show actual number and % in the weight / tooltip ?

I have used my measure (no. of tickets) in the weight, but in additon to that actual measure, I also want to show the %.

e.g.
Out of 200 tickets, 28 came from Finance department for Commercial department, I want to show 28 (14%) in the tooltip. Currently it only shows 28.

Thanks !

[burakkaragoz · Accepted solution]

Hi @Saniat ,

Yeah, totally get what you're trying to do. The default Sankey visual in Power BI (especially the one from the marketplace) doesn't support showing both count and percentage directly in the tooltip or label.

But here's a workaround that usually does the trick:

1. Create a measure that calculates the percentage:

Ticket % = 
DIVIDE(
    [Ticket Count],
    CALCULATE([Ticket Count], ALL('YourTable'))
)

1. Then create another measure to combine both:

Ticket Display = 
FORMAT([Ticket Count], "#,##0") & " (" & FORMAT([Ticket %], "0.0%") & ")"

1. Use this Ticket Display measure in the tooltip field of the Sankey visual.

If you're using a custom visual and it doesn't allow custom tooltips, you might need to explore alternatives like Deneb or Charticulator for more control.

Let me know which Sankey visual you're using and I can tailor the steps better.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[rajendraongole1 · Accepted solution]

Hi @Saniat  - sankey chart, has very limited in tooltip customization and it does not support custom tooltips that include calculated percentages alongside the weight value .

suggest, You can create a tooltip page to display both actual count and percentage. or You might want to try more advanced Sankey visuals like Deneb chart.

Hope this works

[V-yubandi-msft]

Hi @Saniat ,

I hope this information is helpful. Let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank You.

[V-yubandi-msft]

@Saniat ,  have you had a chance to review the responses shared? Did they help resolve your issue? If so, please consider marking it as the accepted solution so it can assist other community members as well.

Thank You.

[V-yubandi-msft]

Hi @Saniat ,

If you've reviewed the responses, you'll notice that @rajendraongole1  &  @DataNinja777have provided valuable insights. Please take a look and let us know if you need any additional assistance.

If any of the posts helped resolve the issue, kindly mark them as an accepted solution, as it could assist other community members facing similar challenges.

Thank you for your time and support.

[DataNinja777 · Accepted solution]

Hi @Saniat ,

The native Power BI Sankey diagram visual does not support showing percentages in the tooltip by default, but you can work around this by creating a DAX measure that combines the raw count and its percentage of the total. First, create a measure to calculate the total number of tickets:

Total Tickets = CALCULATE(SUM('YourTable'[Tickets]), ALL('YourTable'))

Next, create a measure to calculate the percentage of the total:

Ticket % = DIVIDE(SUM('YourTable'[Tickets]), [Total Tickets])

Then create a combined measure that formats both the count and percentage together:

Tickets and % = 
VAR Tickets = SUM('YourTable'[Tickets])
VAR Percent = DIVIDE(Tickets, [Total Tickets])
RETURN Tickets & " (" & FORMAT(Percent, "0.0%") & ")"

Drag this final Tickets and % measure into the Tooltip field well of the Sankey visual. This will show something like 28 (14%) when you hover over the link, giving you both values in one.

Best regards,

[rajendraongole1 · Accepted solution]

Hi @Saniat  - sankey chart, has very limited in tooltip customization and it does not support custom tooltips that include calculated percentages alongside the weight value .

suggest, You can create a tooltip page to display both actual count and percentage. or You might want to try more advanced Sankey visuals like Deneb chart.

Hope this works

[burakkaragoz · Accepted solution]

Hi @Saniat ,

Yeah, totally get what you're trying to do. The default Sankey visual in Power BI (especially the one from the marketplace) doesn't support showing both count and percentage directly in the tooltip or label.

But here's a workaround that usually does the trick:

1. Create a measure that calculates the percentage:

Ticket % = 
DIVIDE(
    [Ticket Count],
    CALCULATE([Ticket Count], ALL('YourTable'))
)

1. Then create another measure to combine both:

Ticket Display = 
FORMAT([Ticket Count], "#,##0") & " (" & FORMAT([Ticket %], "0.0%") & ")"

1. Use this Ticket Display measure in the tooltip field of the Sankey visual.

If you're using a custom visual and it doesn't allow custom tooltips, you might need to explore alternatives like Deneb or Charticulator for more control.

Let me know which Sankey visual you're using and I can tailor the steps better.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.