Forum Discussion
Solved
Measure manipilation
Hi all I am having trouble manipulating data for a shape map visual and hope you can help. My data is as follows Name. Measure A. Measure B Location A. 100. 300 Loc...
Create a new measure for the inverted Measure A:
Inverted Measure A = MAXX(ALL('Table'[Measure A]), 'Table'[Measure A]) - 'Table'[Measure A]
In your shape map visual, replace the original Measure A with the new Inverted Measure A.
Ensure that Measure B remains as it is since it already aligns with your desired color gradient.
Create a new measure for the inverted Measure A:
Inverted Measure A = MAXX(ALL('Table'[Measure A]), 'Table'[Measure A]) - 'Table'[Measure A]
In your shape map visual, replace the original Measure A with the new Inverted Measure A.
Ensure that Measure B remains as it is since it already aligns with your desired color gradient.