Forum Discussion

AR_D's avatar
AR_D
Regular Visitor
1 year ago
Solved

dynamic x axis

Hi everyone Below is the snapshot which right now i am getting    When I am selecting "daily" then it's reflecting day wise, but when "Monthly i selected i want to only show month name o...
Need Help
  • AR_D's avatar
    AR_D
    1 year ago

    Ashish_Mathur FBergamaschi 
    Thanku so much for the reponse

    I came up with one solution and it working now.
    I am using two chart on chart for monthly and second one for the rest of the slicer.
    showing chart when monthly selected and hiding it if other are selected.

    Just used two measure for this and used visual lever filter.

    Once again thank you for the reply.

    Chart A Visibility =
    VAR _Trend = SELECTEDVALUE('Trend_Type'[Trend])
    RETURN
        IF(
            _Trend = "Monthly",
            0,
            1
        )


    Chart B Visibility =
    VAR _Trend = SELECTEDVALUE('Trend_Type'[Trend])
    RETURN
        IF(
            _Trend = "Monthly",
            1,
            0
        )
FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Hi AR_D 

what is at the moment the role of the slicer you showed ?

 

To answer your question:

The only way to dinamically change the field in the x axis is to create a field parameter and include its column in the x axis of the line chart ajd select his value from the automatically added slicer

 

But I want to understand what you are doing now so I can be sure I really answered you

 

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

 

 

AR_D's avatar
AR_D
Regular Visitor
1 year ago

Thanku you the respose FBergamaschi 

Let's suppose i want to show total sales ( total sales is on y-axis)
and on x-axis what should i put

so that it work for all the slicer
like if i select daily then it should show daily datewise total sales 
If monthly is selected then It should show total sales by month ( Note: on x-axis should show month name)

Moving average and daily sales is working if on x-axis, i am putting date column
but by focus is when i select monthly then it should show month wise means on x-axis instead of regular date it should show month name.