Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

SandDance Relationship AND/OR Data Exclusion Issue



I'm using the most recent edition of the SandDance plug and I'm having the following issue: 


When working with two data-sets (say, natural gas pricing AND equity pricing for a natural gas producer) that share a basic data point (like "date") - in "Stacks" view (within the SandDance plug) - if one of the data-sets [the natural gas pricing] pre-dates the other data-set (the equity pricing) I get a large stack column (within "Stacks" view of the SandDance plug) that has "null" values. Obviously, this skews the visual.


Is this a relationship issue of some sort? I would think not given that I'm only using two data-sets and that the relationship 1) auto-detects correctly AND 2) even when I manually complete the relationshiop --- it's a pretty basic relationship (i.e. I feel I'm competently forming the relationship between date/date of the two data-sets). 


I'll try to experiment and solve on my own. If I find a solution, I'll respond with the solution. If others know of the solution --- the solution for excluding the "null" data values please post. This will greatly assist me on a go-forward basis. 


ALSO: I am using both data-sets (each with only two colums of data) in "table" format (which was a solution to another SandDance issue that Lukasz was kind enough and innovative enough to help me solve) prior to and upon data upload from Excel to PBI.






Hi @DallasSalazar,


If hard for us to get your issue base don your description. Could you please provide us a screenshot about your issue, or provide us some sample data, so that we can make further analysis.



Charlie Liao

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.