cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Measures - values sorted ASC

Hi everyone.
Basically I need to create a scatter plot where I will have x and y sorted ascending and plot against each other, ... so the number are not correlated to each other anymore

My table is quite big so I think would be better to have two measures x and y?
BTW. I am going to use DENEB and Vega-Lite to plot the scatterplot

4 REPLIES 4
Helper I

Hi @v-tangjie-msft
I know how to create scatterplot in vega....
I don;t know how to create the measures ... 😉

Community Support

Do you mean an ordering measures of x and y?

``Rank_X = RANKX(ALLSELECTED('Table'),[x],MAX('Table'[x]),ASC,Dense) ``
``Rank_Y = RANKX(ALLSELECTED('Table'),[y],MAX('Table'[y]),ASC,Dense) ``

Best Regards,

Neeko Tang

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

Helper I

Hi @v-tangjie-msft
Not really....
Please take first table and try to create second chart.

Community Support

First, you'll need to create two separate measures for your x and y axes. Once you have your measures or ranked columns ready, you can use them in DENEB with a Vega-Lite specification. Here is a basic example of how you might structure your Vega-Lite JSON to plot the sorted values:

``````{
"\$schema": "https://vega.github.io/schema/vega-lite/v5.json",
"description": "A scatterplot showing sorted x and y values.",
"data": {
"name": "dataset"
},
"mark": "point",
"encoding": {
"x": {"field": "SortedX", "type": "quantitative"},
"y": {"field": "SortedY", "type": "quantitative"}
}
}``````

Best Regards,

Neeko Tang

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors