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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
d_i_rob
New Member

Sankey Chart plots zero as one

Using Sankey 3.4.2.0.  Getting great visuals... until I hit a zero value.  The Sankey plots that as 1. 

The chart even adds up these artificial 1 values to make nodes with five zeroes in into a value 5.  Obviously, this is an undesirable artefact: either the line should display as zero or not be plotted at all.  Is there a setting I missed, or is this a bug?

Thanks, 

David

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

What happens when you filter out zero values?

View solution in original post

3 REPLIES 3
d_i_rob
New Member

Should've thought of filtering out the zeroes.  That does fix it thanks, good idea.  Looks like the product is being looked at too soo all good, very impressive response from the community, big thanks.

v-jianpeng-msft
Community Support
Community Support

Thank you lbendlin

Hi, @d_i_rob 

Based on your description, I used the following dataset to replicate the problem you mentioned:

vjianpengmsft_0-1725945635108.png

It is currently being investigated and I will update here with the results of the investigation if any updates follow.

 

 

Best Regards

Jianpeng Li

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

 

 

 

lbendlin
Super User
Super User

What happens when you filter out zero values?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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