Forum Discussion
Dynamic field and Line and Cluster Column Chart
- Anonymous1 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.
- Anonymous1 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.
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.
Thank you so much for your help, Yolo Zhu. I am a beginner in Power BI and need to learn how to write DAX.