Dynamic field and Line and Cluster Column Chart

[vermillion]

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.

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solution lbendlin  offered,and i want to offer some more information for user to refer to.

hello @vermillion , 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.

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solution lbendlin  offered,and i want to offer some more information for user to refer to.

hello @vermillion , 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.

[vermillion]

Thank you, Yolo.   I love your solution. 

@v-xinruzhu-msft 

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.  

[vermillion · Accepted solution]

Thank you so much for your help, Yolo Zhu.  I am a beginner in Power BI and need to learn how to write DAX.  

[lbendlin]

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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[vermillion]

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.

[lbendlin]

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

[vermillion]

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? 

[lbendlin]

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