Forum Discussion
Posibility to highlight selection on scattered chart without hidinng others
Hello,
I'm here with a question. Is it possible to somehow obtain highlighting or a different color of the dot after selecting a given provider on the slicer/table? Currently, when im select a selection in the slicer, it filters the visualization and displays the one corresponding to a given selection. I would like to somehow find a solution in which there is not just this one dot, but all of them plus this one highlighted in some way.
Is it possible to obtain such a solution by creating some measure or somehow?
In short, I would like to get a slicer that not filters but highlights the selection.
Example:
Actual problem, after selecting one:
Im looking for something like this:
This result is after click one of the dot then highliting this one others went to back. Im looking for something like that but not after clicking on dot at chart im looking for something like slicer. I dont want to user want to check where exacly is his dot and then click i need to he have list select one and it higlight this one on chart.
It is possible?
Thanks in advance for help! 🙂
BR
Hi RoksanaSZ ,
As far as I know, this is the design of Power BI, when you select a value in the slicer, the corresponding Visual will show the highlighted value and hide the rest of the values. As Super User said above, create a separate table as the slicer, so that when you use the slicer, it doesn't affect the visual, and then create a measure to conditionally affect the color of the Visual.
For scatter chart:
You can click Format -- Markers - Color - Default - fx
Go to the Default color screen
Format style : Field value
What field should we base this on : [Measure]
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.
2 Replies
- amitchandak
Super User
RoksanaSZ , if you are using legend, you will not be able to use conditional formatting, so use only details
After that create a disconnected table for the slicer and use that in a measure
Color = if (Max(Table[Category]) in Values(Category[Category]) , "Blue", "Green")
Use it conditional formatting using field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE Hi RoksanaSZ ,
As far as I know, this is the design of Power BI, when you select a value in the slicer, the corresponding Visual will show the highlighted value and hide the rest of the values. As Super User said above, create a separate table as the slicer, so that when you use the slicer, it doesn't affect the visual, and then create a measure to conditionally affect the color of the Visual.
For scatter chart:
You can click Format -- Markers - Color - Default - fx
Go to the Default color screen
Format style : Field value
What field should we base this on : [Measure]
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.
