Table with sorting, filtering, highlighting, ...

[DimitrakisT]

Hello,

We recently run into an interesting problem:
We have a data source that is a table of fixed columns, as well as an additional column with JSON of the form:
{"Column 1": "value", "Column 2": "value", ... }

We have hundreds of records, and potentially hundreds of columns, which we do not know in advance.

We want to show in a ’normal’ table, the columns. I.e. when a type of entity is filtered, only the columns relevant woud show in the table

Would a custom visual built with vega/lite be able to tackle this use-case?
Any directions/recommendations?

[hydrosquall]

1. What would be the guideline for when a column is relevant to be displayed?
2. Are you embedding vega-lite inside a JS application that could dynamically generated a Vega-Lite spec using the appropriate columns based on wherever you're managing which entity is used for filtering?

[montechristos]

This is a thread I had created some time back to explain the use-case
https://community.fabric.microsoft.com/t5/Desktop/Dynamic-table-based-on-JSON-column/td-p/4416378

Please have a look at this, and let me know if it is clear, and I can provide additional info

[hydrosquall]

Thanks for the thread link!

I haven't used PowerBI, but it looks like you can do some scripting there.

Are you able to dynamically generate parts of the Vega-Lite spec that gets passed into Deneb using the scripting language offered in PBI?