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

Hi,

Share the download link of the PBI file.