Forum Discussion
Solved
Color Change in Line Chart based on Slicer Value
I have a Funnel Plot Chart I created in DAX , the Blue dots represent the Percentage , based on a single slicer selection ; I want to change the Dot to red for the given select and still illustrat...
- Hi carlol ,You're right. Maybe it's a lack of function,you can submit your idea to help improve power bi.Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi carlol ,
You need to create a new table and use one of its column as a slicer.
Then create a measure to dynamically change the data color.
Try to use DAX like this:
Measure= IF(VALUES(Table2[value]) IN VALUES (Table1[value]),"#ff0000")
If the problem persists,could you please share sample data or pbix?(Please mask any sensitive data before uploading)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.