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 (5)
RE: Ability to invert the sign () of the measures
Good information, thankssehackear.top
RE: Ability to invert the sign () of the measures
this should be in by now?
RE: Ability to invert the sign () of the measures
fyi you can write a dax expression like amount = ([table].field)* -1
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.
RE: Ability to invert the sign () of the measures
I have the same problem. Would be convenient to have this function.