Forum Discussion
Color based on slicer selection but with different forms, Scatter chart
- 1 month ago
Unfortunately, what you're trying to achieve isn't currently supported by the native Power BI Scatter chart.
When you use:
Legend β Power BI assigns colors automatically by category and disables conditional formatting (fx) for marker colors.
Conditional formatting (fx) for marker color β You can't simultaneously use the Legend to control marker shapes/colors.
So these two features are mutually exclusive in the current visual.
Possible workarounds
Option 1 (Recommended): Use Style instead of Legend (if available)
If you're using the newer scatter chart experience, check whether you can assign your Type field to Marker shape/Style instead of Legend. This allows:Shape = Type
Color = Conditional formatting (your DAX measure)
If your version of Power BI doesn't support this, you'll need one of the alternatives below.
Option 2: Use a custom visual
Some custom scatter visuals (e.g., Deneb or Charticulator) provide much greater control over marker color, shape, and size simultaneously. With these, you can:Color points based on your selected firm.
Assign different marker shapes based on Type.
Keep everything in a single visual.
Option 3: Use a single conditional formatting measure
If you're willing to give up the automatic legend colors, you can keep your DAX measure:color_selected_point = IF ( SELECTEDVALUE(Slicer_firms[FirmName]) = MAX(data[FirmName]), "#FF0000", "#1F77B4" )and use marker shapes (if supported by your visual version) to distinguish the different Type values.
Why this happens
The native Scatter chart currently allows either:
Legend to drive category formatting, or
Conditional formatting (fx) to drive marker colors,
but not both at the same time.
If your goal is blue points with different shapes by Type, and only the selected firm highlighted in red, a Deneb visual is probably the best solution, as it supports independent encoding of color, shape, size, and other attributes.
For more information:
Scatter charts in Power BI: https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-scatter
Conditional formatting in Power BI: https://learn.microsoft.com/power-bi/create-reports/desktop-conditional-table-formatting
Deneb custom visual: https://deneb-viz.github.io/
π‘ Helpful? Give a Kudos π β keep the community growing.
β Solved your issue? Mark this as the Accepted Solution βοΈ
Best regards, Prince Singh | Data Science & Microsoft Fabric Enthusiast
- 1 month ago
Hi jsteffe
are you looking for an output similar to this ?
If this is the output you're expecting, follow the steps below:
- Install the Enhanced Scatter Plot visual.
- Select your existing Traditional Scatter Plot.
- Click the Enhanced Scatter Plot visual icon to switch to the new scatter plot.
- Drag and drop the Type column into the Shape field.
- Turn on the Fill Points toggle.
I have attached a sample that I created for your reference.
Hi jsteffe ,
Wanted to let you know that unfortunately, the requirement is not possible with the native Power BI Scatter chart due to a limitation in how formatting works.
The Scatter chart supports two mutually exclusive behaviors
No Legend: Conditional formatting (Fx) for marker colour is available but marker shape cannot vary by a field.
Legend populated: Marker shapes/colors are automatically assigned per legend category. The Fx button for Marker Color disappears, so you cannot conditionally color the selected point.
I believe this is you are experiencing. Hence, both requirements are not satisfied at same time.
I would suggest you to use custom visuals if your organisation permitted.
Best option: Enhanced Scatter
- Details --> FirstName
- Shape --> Type(this alone drives marker shape)
- Legend --> leave empty
- Color --> keep your existing fx measure (custom colour)
Thanks,
If you found this solution helpful, please consider giving it a Likeπ and marking it as Accepted Solutionβ. This helps improve visibility for others who may be encountering/facing same questions/issues.
- jsteffe1 month agoHelper III
Hi and thans a lot for your answer.
Your solution works when I transform my ScatterChart in an Enhancedscatter Visual (it means that my color conditionnal function was already linked in my first visual). But in new visual I don't see the Fx.
But I want to create a new EnhancedScatter (start from nothing), I don't see the Fx button in the color menu ...
Thanks again for your help