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.
Thanks, Ibendlin, for your prompt reply. Here is a link to Google Drive for files
https://drive.google.com/drive/folders/19XWky9rj5hgF5MV-Gqfr29BN8-74Y4vn?usp=drive_link
My expected outcome is that I would like to have both dynamic fields, "Site dollar" and "ZTA maturity level," be shown in a "line and clustered chart," so when I click on the ABC sites dynamic field, the ABC ZTA dynamic field will also be displayed on the line chart (corresponding). It is the same as other DEF and HJK sites and DEF and HJK ZTA maturity levels.
Currently, when I click on the ABC site dollar dynamic field, I have to click on the ABC maturity field to display both values on the line chart of "line and clustered chart." When I changed the the field to DEF site dollar, the value of the DEF Maturity level will not be altered correspondingly unless I have to click on the DEF Maturity level dynamic field.
Thank you for your help.
Looks like you are trying to use a Field Parameter as a column legend. I don't think that is a supported scenario.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
- Anonymous1 year agoNot applicable
Thank you so much for your prompt reply. I searched the forum and saw a couple of users with problems similar to mine. Would it be possible for us to code Dax or something to make it work?
- lbendlin1 year agoSuper User
I don't think that is a supported scenario yet. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com