Forum Discussion

WeiKeongTan's avatar
WeiKeongTan
Frequent Visitor
1 year ago
Solved

Issues with Scatter Chart and Slicer

Hi,  I would like to create a scatter chart in Power BI to visualize the spatial locations of semiconductor die based on their X and Y coordinates. The goal is to enable dynamic highlighting of spec...
Need Help
  • MasonMA's avatar
    MasonMA
    1 year ago

    Hi:

    One of the workarounds is to create one disconnected table for ORTAG_U1 slicer, 

    QRTAG_U1_Slicer = VALUES(wafer[QRTAG_U1]).
     
    Then for the conditional formatting on die color, if you wanted to highligh single die in red, you can use this below, 
    Die_Color1 =
    VAR _SelectedQRTAGs = SELECTEDVALUE(QRTAG_U1_Slicer[QRTAG_U1])
    RETURN
    IF (
        MAX(wafer[QRTAG_U1]) = _SelectedQRTAGs,
        "Red",
        "Blue"
    )
     
    If you would like to multi-highlight dies in red, you may use this measure below:
    Die_Color2 =
    VAR _SelectedQRTAGs = VALUES(QRTAG_U1_Slicer[QRTAG_U1])
    VAR _HasSelection = ISFILTERED(QRTAG_U1_Slicer[QRTAG_U1])
    VAR _CurrentQRTAG = MAX(wafer[QRTAG_U1])
    RETURN
    IF (
        _HasSelection && CONTAINS(_SelectedQRTAGs, QRTAG_U1_Slicer[QRTAG_U1], _CurrentQRTAG),
        "Red",
        "Blue"
    )
     
    Thanks 
    Mason
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi WeiKeongTan,

Thank you for reaching out in Microsoft Community Forum.

Thank you MasonMA    for the helpful response.

As suggested by MasonMA,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.