Forum Discussion
Changing visual to a single object
there may be better ways to visualize this - maybe with a line chart with different colors for car and acceleration.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks for your reply.
The reason I chose line and stacked visual is to have a background color to indicate whether a car is accelerating or decelerating. I use that measure on the stacks.
I also used a slicer in this case. It works for the other visuals but not for this visual in particular.
The reason is because in the line and stacked column visual I'm using a custom measure called accelerating(to populate the stacks) on the legend. If I use carId on the legend, then the slicer works as it has a connection it. The problem is I can't use both..