Forum Discussion
Helper IScatter Plot - Highlight Single/Multiple points via Slicer
I've seen multiple Questions about how to highlight a single point on a scatter plot, but they don't seem to be as complex as my needs. I'm working with a single table, but with the need to use 2 slicers. 1 slicer for a customer and another slicer for product. You would select the customer first and then a product(s).
Is there a way to highlight the product(s) on a scatter plot after selecting the customer?
Here is a sample PBIX:
https://drive.google.com/file/d/1idk72rmLr5C1Eawdj4hHAv5sk7KAh-Rj/view?usp=sharing
Here is a sample screenshot of what I'm trying to accomplish:
Hi 8shipsbynight ,
If you want to give each product a color, you can only define a color for each product in the Switch() function.
If in your expected result, the product can be divided into each area to give the color, you can set an Index for the product, and set the color in a certain interval, which will be more convenient.
1. In Power query, add Index to 3 tables, Add Column – Index Column – From 1.
2. Create measure.
Flag_color = var _selectpn=SELECTEDVALUE('MOCK_DATA'[prod number]) var _selectp=SELECTEDVALUE('MOCK_DATA'[product]) var _value=CALCULATE(SUM('MOCK_DATA'[Inex]),FILTER(MOCK_DATA,'MOCK_DATA'[prod number]=_selectpn&&'MOCK_DATA'[product]=MOCK_DATA[product])) return SWITCH( TRUE(), _value>0&&_selectp<100,"red", _value>0&&_selectp<100,"yellow", _value>0&&_selectp<100,"black", _value>0&&_selectp<100,"blue", "white")Then put it in Visual - Format - Data colors - fx to set.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
5 Replies
- amitchandak
Super User
8shipsbynight , Based on what I got
Enable this option, After the press ctrl or Shift and you will be able select multiple point on scatter(click and drag) , they will get filtered on other visuals
8shipsbynightI'm looking for something more like this https://community.powerbi.com/t5/Desktop/Scatter-Plot-Highlight-data-point-via-Slicer/m-p/890895
The slicer is what determines the dots that get highlighted.
The solution in the link above is great, but doesn't incorporate more than 1 slicer. My PBI report will filter on a customer first, then a product. And when I select a product, I want those dots associated to the product to be a different color on the scatter plot. Is this feasible?
Hi 8shipsbynight ,
Here are the steps you can follow：
1. Create measure.
Flag = var _select= SELECTEDVALUE('MOCK_DATA'[acct Name]) return SWITCH( TRUE(), _select="Auto Company","red", _select="Box Store","green", "blue")2. Click Visual - Format - Data colors -- fx
3. Enter the Default color interface.
Format style – Field value
What field should we base this on – [Flag]
4. Result:
The selection is Auto Company, shown in red:
The selection is Box Store and the color is green:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- 8shipsbynight
Thanks Anonymous
This looks like it is moving in the right direction. I don't want to color the dots by Acct Name or account. I want to color the dots by product/prod number.
I see that you programmed "Auto Company" to be red and "Box Store" to be green - this is great if you only have a handful of items in the slicer that you want to highlight two different colors....but what if I have thousands of different items in the slicer?
Hi 8shipsbynight ,
If you want to give each product a color, you can only define a color for each product in the Switch() function.
If in your expected result, the product can be divided into each area to give the color, you can set an Index for the product, and set the color in a certain interval, which will be more convenient.
1. In Power query, add Index to 3 tables, Add Column – Index Column – From 1.
2. Create measure.
Flag_color = var _selectpn=SELECTEDVALUE('MOCK_DATA'[prod number]) var _selectp=SELECTEDVALUE('MOCK_DATA'[product]) var _value=CALCULATE(SUM('MOCK_DATA'[Inex]),FILTER(MOCK_DATA,'MOCK_DATA'[prod number]=_selectpn&&'MOCK_DATA'[product]=MOCK_DATA[product])) return SWITCH( TRUE(), _value>0&&_selectp<100,"red", _value>0&&_selectp<100,"yellow", _value>0&&_selectp<100,"black", _value>0&&_selectp<100,"blue", "white")Then put it in Visual - Format - Data colors - fx to set.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
