DAX- show Netural on Negative and Positive side of Axis.

[shilpa288]

I have two columns holding positive and Negative values which is written in Dax.

I want to show them in one column. I have to show these values on X axis and have to show Netural on both positve side and negative side of X axis. My issue is with Neturals. which I am not able to show on both side of axis.

How can I achieve this ?

Thanks

[shilpa288]

Thank you 

[lbendlin · Accepted solution]

In Power Query you can append tables if they have the same column name or not. But in your case you want them to have the same column  names

- Create a reference of the original table, remove the negative value column and rename the positive value column to "Value"

- Create another reference of the original table, remove the positive value column and rename the negative value column to "Value"

- append those two tables and filter out the empty values.