Forum Discussion

Tahech's avatar
Tahech
Icon for Helper I rankHelper I
4 years ago
Solved

How to change X-Axis conditionally?

My problem:   I'm visualizing a graphic in Months (x-axis) by Value (y-axis).   When I click over June (for example) I want to change the x-axis from "Month" to "Clients". Then my graphic will sh...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

    Creating a new table.

    Axis table = 
SELECTCOLUMNS (
    UNION (
        ALL ( 'Calendar'[Month-Year], 'Calendar'[End of Month] ),
        ALL ( Clients[Clients], Clients[Index] )
    ),
    "@Axis", [Month-Year],
    "@index", 'Calendar'[End of Month]
)

     

    Creating a measure

    Desired outcome measure: = 
IF (
    NOT ISFILTERED( 'Calendar'[Month-Year] ),
    CALCULATE (
        SUM ( Data[Value] ),
        TREATAS ( VALUES ( 'Axis table'[@Axis] ), 'Calendar'[Month-Year] )
    ),
    CALCULATE (
        SUM ( Data[Value] ),
        TREATAS ( VALUES ( 'Axis table'[@Axis] ), Clients[Clients] )
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

Creating a new table.

Axis table = 
SELECTCOLUMNS (
    UNION (
        ALL ( 'Calendar'[Month-Year], 'Calendar'[End of Month] ),
        ALL ( Clients[Clients], Clients[Index] )
    ),
    "@Axis", [Month-Year],
    "@index", 'Calendar'[End of Month]
)

 

Creating a measure

Desired outcome measure: = 
IF (
    NOT ISFILTERED( 'Calendar'[Month-Year] ),
    CALCULATE (
        SUM ( Data[Value] ),
        TREATAS ( VALUES ( 'Axis table'[@Axis] ), 'Calendar'[Month-Year] )
    ),
    CALCULATE (
        SUM ( Data[Value] ),
        TREATAS ( VALUES ( 'Axis table'[@Axis] ), Clients[Clients] )
    )
)