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, Yolo. I love your solution.
Anonymous
However, there is cases that "All Site Dollar" has couple sites requests money but they don't have Maturity level measures and vise versa. Please help me. I uploaded the new dataset to my Google Drive below
https://drive.google.com/drive/folders/19XWky9rj5hgF5MV-Gqfr29BN8-74Y4vn?usp=sharing
Thank you so much for your help.