Vertical dot chart for different measures

[Pk8524]

I wonder if its possible to create such graph:

but to have in the x axis different measures:

The goal would be to show different measures, how all categories are performing within each measure, and highlight the one choosen by the user. Is it possible to have on x axis diffrerent measures (not creating several charts next to each other)? For the simplicity I am using here two measures total sales and total sales dummy.

https://drive.google.com/file/d/1Pm-f9kOZ6BSBXukUQ-PcRVBHMahwa4Tw/view?usp=sharing 

[v-junyant-msft · Accepted solution]

Hi @Pk8524 ,

Thanks for lbendlin's reply!
And @Pk8524 , 
First of all, if you want to achieve the effect shown in this picture:

Then you are currently using the wrong visual object.

You need to use Scatter chart:

In addition, you need to put different measures into the visual object, but no matter which visual object, you can only put one measure in the Y-axis.

You need to add a new table with one column containing all the Values ​​that will appear on the x-axis (the names of all the measures to be displayed). For example:

Then use this DAX to create a measure:

Measure = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Table'[X-axis]) = "Measure1", [Total Sales],
    SELECTEDVALUE('Table'[X-axis]) = "Measure2", [Total Sales Dummy]
)

Put the column X-axis into the X Axis of the Scatter chart and the measure into the Y Axis of the Scatter chart:

The example is on the second page of the pbix I gave you.

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

[lbendlin]

It's the wrong chart type. Your X axis items are sorted randomly  (alphabetically).  A Radar chart may be more appropriate.

What distinguishes Measure1 from Measure2 ?  In other words - apart from the SubCategory what is the other defining dimension that should go on the x axis? Customer?