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.