Finding MAX/MIN of multiple measures

[rhl94]

Hi,

I have a clustered bar visual that can go in either direction, depending on if the deviation is positive or negative.

I have two issues. The current graph looks like this. The report is supposed to be dynamic, so if I filter for a different department, the numbers will change, and maybe the grey bar will deviate the most. Therefore I can't adjust the X-axis to a fixed number.

I'd like to:

• Make sure there are always enough space to show the data label for each bar outside. To do so, I would like to make a measure that takes the MIN/MAX of the values and subtracts/adds one. This new measure would be added to the graph, but in white so that it can't be seen. The problem is that the 4 bars are based on their respective 4 measures, so I can't just take "MIN(Measure1, Measure2, Measure3, Measure4)-1" to find the lowest number. How can this be done? Is there a better way?
• Is it possible to make the 0 on the X-axis centered to the middle at all times? Maybe this can be incorporated in the above measure/fix

Any help is appreciated.

[v-piga-msft]

Hi @rhl94 ,

Have you solved the problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please free to ask.

Best Regards,

Cherry

[v-piga-msft]

Hi @rhl94 ,

If I understand your requirement correctly that you want to calculate the MIM or MAX of the multiple measures.

I'm afraid that the there is no direct functions in dax to achieve that.

I think you could create a variable calculated table with the measures and the calculate the max and min measure.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry