Forum Discussion

Malekz's avatar
Malekz
Frequent Visitor
2 years ago
Solved

Scatter Chart Axis Focus

Hello Community, 

 

Is it possible to automatically made a scatter chart focus on the part where there is a lot of values for example I have this scatter chart: 

 

Is it possible to have directly this : 

 

Thanks for your help

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,Malekz 
    I am glad to help you.

    According to your description, you want to automatically adjust the focus of the scatterplot to highlight areas with a high density of values.

    If the data is concentrated in a small area

    1. You can try turning on the option Logarithmic scale button.
    In Power BI, the logarithmic scale is used to create visual representations of data, especially when the data range is very large, very small, or has a wide range of values. By using a logarithmic scale, charts can display small and large values on the same scale, making it easier for you to compare and interpret data.

     

     

    1. You can try manual axis adjustment

    According to your description, you have already manually adjusted the X-axis and Y-axis ranges during the demo to focus on a range of centralized data.

    This is also a good way

    1. Adjust the data display range in the chart by writing DAX code or creating a slicer.

    By adding a slicer to the x-axis or y-axis variable in visual, you can use the slicer to select a specific range of data to focus on, effectively zooming in on high density areas.

    You can also use Dax code to actively filter the data and display only the filtered results after Dax code calculations.
    like this:

    M_test = CALCULATE(SUM(Tabelle1[Total]),'Tabelle1'[value_1]<100)​

    here is my test data:

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,Malekz 
    I am glad to help you.

    According to your description, you want to automatically adjust the focus of the scatterplot to highlight areas with a high density of values.

    If the data is concentrated in a small area

    1. You can try turning on the option Logarithmic scale button.
    In Power BI, the logarithmic scale is used to create visual representations of data, especially when the data range is very large, very small, or has a wide range of values. By using a logarithmic scale, charts can display small and large values on the same scale, making it easier for you to compare and interpret data.

     

     

    1. You can try manual axis adjustment

    According to your description, you have already manually adjusted the X-axis and Y-axis ranges during the demo to focus on a range of centralized data.

    This is also a good way

    1. Adjust the data display range in the chart by writing DAX code or creating a slicer.

    By adding a slicer to the x-axis or y-axis variable in visual, you can use the slicer to select a specific range of data to focus on, effectively zooming in on high density areas.

    You can also use Dax code to actively filter the data and display only the filtered results after Dax code calculations.
    like this:

    M_test = CALCULATE(SUM(Tabelle1[Total]),'Tabelle1'[value_1]<100)​

    here is my test data:

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

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