Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Changing visual to a single object

Hi guys,   I have a situation but having difficulty what the actual problem is, so I used a generic title hoping it would be accurate.   I have tables as follow(Car.CarId references to CarDetails...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Not very clear about this——I'm using a custom measure called accelerating(to populate the stacks) on the legend. Because to my knowledge, measures could not be applied to Legend field.

 

Could you please share me with your pbix file after removing sensitive data to help us clarify your scenario?

Refer to:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

Best Regards,
Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your reply!

 

I've added the .pbix file link:

https://drive.google.com/file/d/18T5pjmOg0GnZJIw1-JTRudmVQEBthvXC/view?usp=sharing 

 

As you can see currently, there is no visualization because the x axis scale is way off from GameTime's values. If you remove TrainId from Legend column in the visual, it shows overlapping data from multiple Trains. Using the slicer, I want it to show data of only 1 train. This way, there would be no overlapping data since this visual is meant to show only 1 object at a time. 

 

Hopefully I was able to explain my problem.

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Thank you for providing the sample data. That helps a lot with proposing a potential solution.

     

    Your problem is that you have blank TrainStateIDs in the LogItems table. Please explain/correct.

     

    There is another problem - a bug in the Small Multiples view - it does not properly show x axis if the value is time only (without a date).  Converting the time to decimal works.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for your reply!

      Not all LogItems does have TrainStates. The empty ones are part of another datasets.

      I noticed the Small Multiples View having issues with the x axis and I couldn't fix it. Converting to decimal is not really a solution I like. I don't understand why the x axis scale wouldn't go from lowest value to highest value in the GameTime column?

      The visual that you posted misses the 'Accelerating' column. With this, the column stacks have different colors based on the IF statement. (Accelerating, Decelerating, Stable). 

      I also tried to make it work without Small Multiples Views and by using a slicer to only show 1 Train object. I failed in that too.