Forum Discussion

Spartacus91's avatar
Spartacus91
Frequent Visitor
4 years ago
Solved

Color based on slicer selection, Scatter chart

is it possible that the value I select from my slicer will get one color (for instance red) in my scatter chart, while all other values remain another color (for instance blue)?   Also when I chose...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    Spartacus91 create a separate table for the slicer value and it will not have any relationship with your main table. Write the following measure for the color and then use it in the conditional formatting:

     

    Selected Color = IF ( SELECTEDVALUES ( SlicerTable[Slicer Column] ) = MAX( YourTable[YourColumn] ), "Red" )

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❀ Kudos if my solution helped. πŸ‘‰ If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚑ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚑

parry2k's avatar
parry2k
Super User
4 years ago

Spartacus91 create a separate table for the slicer value and it will not have any relationship with your main table. Write the following measure for the color and then use it in the conditional formatting:

 

Selected Color = IF ( SELECTEDVALUES ( SlicerTable[Slicer Column] ) = MAX( YourTable[YourColumn] ), "Red" )

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❀ Kudos if my solution helped. πŸ‘‰ If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚑ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚑