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
MasonMA's avatar
MasonMA
Super User
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
  • WeiKeongTan's avatar
    WeiKeongTan
    Frequent Visitor
    1 year ago

    Thanks, Mason! I tried the workaround, and it works perfectly. Really appreciate your guidance!