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.