Forum Discussion

Pk8524's avatar
Pk8524
Helper I
1 year ago
Solved

Vertical dot chart for different measures

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 

  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.