Forum Discussion
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" for Line Y-Axis (line chart). When I clicked on mABC Dollar, I have to click on MinABC ML to make graph for site ABC correct for dollar vs zta maturity level. Do you have a way that I click on mABC Dollar in dynamic field, the value of MinABC ML changes corresponding with mABC Dollar? it is the same to mDEF Dollar and mHJK Dollar. Thank you so much for your help. They X-Axis is Fiscal Calendar. Below is snapshot.
Vermillion.
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.
8 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thanks, 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
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.
