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 show me the days of the month select (June) e the Value (y-axis) by Clients (the new x-axis)

 

Is it possible?

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] )
    )
)

3 Replies

  • 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] )
    )
)
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Tahech ;

    Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


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