Forum Discussion
Solved
Dynamic Max for X axis for multiple charts
Hi, Can you help me create a measure to dynamicaly customize Max Value for X axis, please? It should cover all scenarios below. 1. Max Value for all 3 charts should be set up to 275. 2...
Ahh I didn't know the structure of your data so guessed.
Highest city =CALCULATE(MAXX(SELECTCOLUMNS('Table', [Category]),MAXX(SELECTCOLUMNS('Table',[City]),[sum city sales] )),all('Table'[Category]))Change the Inner MAXX to SelectColumn(table,city) that will do the calculation per city instead of per row.
Hi SamWiseOwl Thank you for reply. Please correct me if I am wrong, but your idea returns the value for record with highest Sales per City, not the highest Sales per City as a Sum of Sales per City what I need.
Hi karo
Did you open the attached file?
It appears to work for each given scenario
275 for all regions
region 1: 75
Region 2: 275
SamWiseOwl yes, I opened it. It was really helpful that you attached the file with the solution. However, please split the 275 in the source table into for example 250 and 25 and then you will see what I mean.
Ahh I didn't know the structure of your data so guessed.
Highest city =CALCULATE(MAXX(SELECTCOLUMNS('Table', [Category]),MAXX(SELECTCOLUMNS('Table',[City]),[sum city sales] )),all('Table'[Category]))Change the Inner MAXX to SelectColumn(table,city) that will do the calculation per city instead of per row.Thank you ❤️