Custom visualization that expands JSON to columns dynamically

[Montechristos01]

This is a re-posting of another thread, but this time for a custom visual:
https://community.fabric.microsoft.com/t5/Desktop/Dynamic-table-based-on-JSON-column/m-p/4418782#M13...

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", ... }

The table represents records from different entities that fail some validation criteria.
(let's say 100 entities in total, each entity with 20 columns, each entity containing 500 failing records)

We will never show a single table for different entities together, we will first filter on each entity separately.

Once the filtering is done, we want to display all the records of this entity in an expanded table.

We could build one report per entity, expanding all its JSON columns, but this is too cumbersome.

Hence the need to filter 1st, and then display the expanded table.

The table should be a 'normal' PBI table, with sorting, filtering, conditional formatting, etc.

This is the output expected after filtering on 'Apples'

 

Any direction on how to achieve this is welcome

[lbendlin]

The only way you can get this to work is to unpivot the data.  Then you can let the matrix visual do the re-pivoting.