cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Booth070 Frequent Visitor
Frequent Visitor

Total % in Sankeys source

Hi,

 

I am trying to plot some percentages of achievement for a metric in a Sankeys visual. The problem comes when hovering over one of the source points: the % shows as the sum of all links percentages. 

 

Is there a way of solving this or is just something impossible to fix for now?

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Total % in Sankeys source

@Booth070,

Please check if the measure in the PBIX file below returns your expected result.

https://1drv.ms/u/s!AhsotbnGu1Noky7VkdXzziNBVagp

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Total % in Sankeys source

@Booth070,

Please check if the measure in the PBIX file below returns your expected result.

https://1drv.ms/u/s!AhsotbnGu1Noky7VkdXzziNBVagp

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Booth070 Frequent Visitor
Frequent Visitor

Re: Total % in Sankeys source

Hi Lydia. Thanks for the example.

 

Using your measure I have calculated the weight of each patway and multiplied each for their achievement so now it seems fixed. The achievement on each link shows as a percentage of the source but that is a minor issue.

 

Thanks a lot!