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.
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 ❤️