Forum Discussion

karo's avatar
karo
Advocate V
1 year ago
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...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    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's avatar
SamWiseOwl
Super User
1 year ago

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.
karo's avatar
karo
Advocate V
1 year ago

Thank you ❤️