cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## Finding MAX/MIN of multiple measures

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.

2 REPLIES 2
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors