Forum Discussion

sjariwala's avatar
sjariwala
Regular Visitor
3 years ago

SandDance visual in PowerBI - Sort multiple axis in visual and add lines to connect scattered dots

Hello,

 

I have data with multiple columns in PowerBI where I want to sort 2 columns in a particular order, first sort Tenor and then sort Expiry by Tenor. I've attached an example below, the left 2 columns are unsorted, but the right 2 columns are expected to be sorted as shown

 

  

Post this, I also want the X and Y axis in the SandDance 3D visual to be sorted as above which is currently unsorted and looks as below:

 

 

After sorting, I also want to add lines to connect the scattered dots in visual for better understanding similar to a surface line as the scatter points themselves aren't that readable. However, the current chart options available in Sandance are only following 

I want to achieve the 3D chart something similar to this:

The surface line helps to clearly understand the visual with values on both axis

No RepliesBe the first to reply