Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Dynamic field and Line and Cluster Column Chart

Good afternoon/Morning All,   I created dynamic field for "All Site Dollar" and "ZTA Maturity Level" and put dynamic field "All Site Dollar"  in Y-Axis (for Column chart) and "ZTA Maturity Level" f...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,

    Thanks for the solution lbendlin  offered,and i want to offer some more information for user to refer to.

    hello Anonymous , you can refer to the following solution.

    You can use the custom visual, pre-selected slicer.

     

    Then create a new table true/false.

     

    And create a measure

    Flag =
    IF (
        ISFILTERED ( 'All Site Dollar' ),
        IF (
            SELECTEDVALUE ( 'ZTA Maturity Level'[Parameter Order] )
                IN VALUES ( 'All Site Dollar'[All Site Dollar Order] ),
            TRUE (),
            FALSE ()
        ),
        FALSE ()
    )
    

    Then create the preselected slicer,  and put the following field to it.

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thank you so much for your help, Yolo Zhu.  I am a beginner in Power BI and need to learn how to write DAX.