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.
- Anonymous1 year agoNot applicable
Thank you so much for your help, Yolo Zhu. I am a beginner in Power BI and need to learn how to write DAX.
- Anonymous1 year agoNot applicable
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.