Speckle Power BI - Colours not matching

Hello team,
I am looking to prepare a dashboard for one of our clients. The limitation which I came across is the matching of colours in Power bi to other graphs or charts.

Is there any workaround or development around this ?

1 Like

Hi there! Welcome to our community @Rahul.sehgal

This has been requested before, and I started looking at how that could work, but I don’t have an ETA at the moment for when this will happen.

I can say for sure that it will happen, as without consistent colors, a dashboard looses a lot of it’s meaning and readability.

Thanks for bringing this up though! If you have more requests (or issues :cold_sweat:) don’t hesitate to let us know.

We’ll keep you posted on this thread whenever we get to it! :raised_hands:t3:

1 Like

Thank you Alan for the quick reply!

To share some more context, the project team needs to submit to the client on April 28, which is very soon. It’s a stadium project and the team showed the initial dashboard to the client. The client was happy with the 3D model but pointed out the colors don’t match and didn’t find it usable in it’s current state, unfortunately.

I can imagine there is a pile of other feature requests and things to develop so could you shed some light on this specific feature and how it might fit in the roadmap? Then we can set expectations for the team so they can wait for this new feature :slight_smile: or… look into other solutions :frowning:

Either way, we are happy with all the stuff the Speckle team is working on!

Since it was mentioned somewhere else on the forum that Power BI is a focus in the next coming weeks, we’d like to share a bit more feedback on two items. These two items have, in our opinion, less priority than matching the colours correctly, but we thought it would be good to share.

  1. If the input on Object Data contains special characters coloring doesn’t work. Renaming a parameter in the right hand pane doesn’t work, the parameter name needs to be specified correctly in the query itself. So if we would “data.name” to “testing” and reapply it to the viewer the colours don’t show up.

  2. When replacing the parameter in the Object Data the viewer isn’t updated. You first need to switch to a different tab and go back to refresh the viewer.

2 Likes

Quick sneak peek of what’s coming up just to get you drooling :drooling_face:

I just managed to get this working today so end result may not behave exactly as the gif… but as always feedback and wishlists are welcome! :raised_hands:t3:

2023-05-04 16.46.51

5 Likes

As for this @JdB

  1. This one has been fixed and will be coming in our next release of PowerBI: We’re no longer relying on speckle data to color the objects. Instead, we’re creating an object map using the powerBI API, meaning you can now also color the model using values that were not present in the speckle model in the first place.
  2. I can’t reproduce this in the latest version, i’ve rewritten a lot of the logic so I may just have fixed it inadvertently, I’ll keep an eye for this anyway. Thx!
3 Likes

:drooling_face:! .

2 Likes

Great stuff! As always :sunglasses:

Feedback Time!!!

Would you rather have this type of selection? Where the selected objects are shown in “Speckle blue” color?

Or this type of selection, where we ghost everything except what’s selected?
2023-05-05 13.43.10

Or would you rather have this as a toggle in the visual settings?

2 Likes

I personally prefer Ghost one.
Alan, you are killing it. ! It seems its pretty much aligned what we are looking for. For your testing can you please include some categories visualisation like furniture or MEP, AHU’s etc just to understand how it responds respectively.

Lastly, My major aim is to visualise the construction sequencing with connecting Power Bi and Revit Through speckle.

3 Likes

Cool! I think ghosting looks better and you can clearly see where the selected objects are positioned. So maybe just role with that for now until someone has specific needs for a different approach?

2 Likes

Amazing, I’m also leaning towards the ghosting one as a default.

Will do :raised_hands:t3: If you share with me a model (or part of it) i can test with that. I don’t have many MEP models to test with.

I think this should be doable with some “selection” + “slicing” options. We still need to properly implement “drill-down” (which I’ll confess I still don’t fully understand) :sweat_smile:

You an consider Autodesk sample project may be ?

1 Like

FYI, I just released this morning a new version of both the Data Connector and the 3D Visual.

I still have to update the docs (next week), but if you’re keen feel free to give it a try!

You’ll need to update both, as the data connector has a new column in it’s output table that is required as input for the visual to work

2023-05-12 11.38.03

2 Likes

Hello its me again,
I believe there is a bug in colour matching in new visual as well. When you take the parameters from drill down query, colours starts to mismatch.

Thanks
Rahul

2 Likes

Small detail (but maybe important to reproduce the error), the parameter has been renamed in the query editor.

Is the sorting in the 3D visual the same as the one your chart uses?

Can you show me a gif of exactly how you get to the missmatched colors?

yes its highlighting the same zones but in donut chart its orange and in the 3D view its blue. I hope this helps