Skip to main content

Power BI

Needs Votes

Ability to invert the sign () of the measures

Vote (14) Share
Power BI User's profile image

Power BI User on 08 Sep 2015 18:48:32

It would be good to be able to invert the value sign of all measures in a chart.
I have Finance Data with Income as positives and expenses as negative - when I do an expense analysis chart off the measure values are negative. Would be good to be able to quickly invert the format of the axis of the chart (as can be done in tableau)

Comments (4)
Power BI User's profile image Profile Picture

Ben Opit on 06 Jul 2020 00:16:42

RE: Ability to invert the sign () of the measures

this should be in by now?

Power BI User's profile image Profile Picture

Ben Opit on 06 Jul 2020 00:16:42

RE: Ability to invert the sign () of the measures

fyi you can write a dax expression like amount = ([table].field)* -1

Power BI User's profile image Profile Picture

Elise on 06 Jul 2020 00:08:10

RE: Ability to invert the sign () of the measures

This would be great! You can't change to absolute values due to credit notes so a new functionality would be very handy. At the moment we insert a new column with a formula but hoping there is a better way to achieve the same outcome.

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:05:44

RE: Ability to invert the sign () of the measures

I have the same problem. Would be convenient to have this function.