Forum Discussion

AuroraNI's avatar
AuroraNI
Helper III
6 years ago
Solved

Highlight single point on scatter plot using slicer instead of filtering

Hi, I would like a slicer to highlight or conditionally format the data point in a scatter plot when you select a value in a slicer.  I attach a photo below.  I would like to choose a single name in...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    AuroraNI 

    I think this is what you are after:

     

    The method I followed was:
    1) In power query, create a "Highlight ID" in the main table (basically concatenate [name] & [Time (secs)] & [x with jitter])

    2) In power query, create a Dimension Table (for your slicer) including [name] and [Highlight ID]

     

    3) load into the model. Make sure there are no relationships between the fact table and the newly created Dim table.

     

     

    4) Set up the slicer using the [Name] field from the newly created 'Dim Table Name'

    5) Set up the scatter chart as you have done with the "x with jitter" and "Time (secs)" as your axes (make sure the fields are not summarized or aggregated). Both these fields are obviously from the main fact table.

    6) Create you conditional formatting measure, like:

     

     

     

     

    Condit Format Highlight measure = 
VAR check = VALUES('Dim Table Name'[Highlight ID])
VAR table_= VALUES('scatter chart highlight'[Highlight ID])
VAR calc = COUNTROWS(
   INTERSECT(check, table_))
Return
IF(calc =1, 2)

     

     

     

     

    5) Use this measure as your "Rule field" in the conditional formatting inputs (set the colour for a true of "2"

    And that's it.

    PS. You might find some points are not visible. This is because of the density of the data (some points may be "hidden" behind others). You might have to play around with the bubble size option, the fill point or the actual colours

     

    Here is the PBIX file for your reference: