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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sjariwala
Regular Visitor

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

PBI Community Sorting.JPG
 

  

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:

 

sjariwala_1-1689626240141.jpeg

 

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 

sjariwala_2-1689626240142.png
I want to achieve the 3D chart something similar to this:
sjariwala_0-1689874172438.png

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

0 REPLIES 0

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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