Scatter Chart positive and negative values in different legend but same month duplicates in x axis

[jessalbea]

Hi anyone here knows how to fix duplicate x axis in Scatter chart when there is a positive value and negative value in same month (x axis) but different category (legend)

[v-yuezhe-msft]

@jessalbea,

Instead of formatting your negative values using Format() function in Power BI Desktop, please change value of “Negative currency format” from -$1.1 to ($1.1) in Region Settings of your computer, then restart your Power BI Desktop, change currency format following the guide in the blog below.

https://www.tringuyenminh92.com/index.php/2018/04/14/format-negative-currency-values-in-parentheses-...

This way, you will be able to remove duplicated X-Axis values in scatter chart.

Regards,
Lydia

[jessalbea]

Hi @v-yuezhe-msft

I am using azure analysis tabular model as source of PowerBI. I already did what you've suggested but still doesn't remove the duplicates of MonthYear (x axis) when there is a positive and negative value in same MonthYear but different category (legend). 

Thank you and Regards,

Jessica

[v-yuezhe-msft]

@jessalbea,

What is the result when you import a small set of data from the Azure AS model using import mode?Could you please share sample data of your original table here?

Regards,
Lydia