Custom visualization that expands JSON to columns dynamically

Montechristos01 — Thu, 20 Feb 2025 10:48:05 GMT

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#M1374603

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

Re: Custom visualization that expands JSON to columns dynamically

lbendlin — Sat, 22 Feb 2025 17:08:53 GMT

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.

topic Custom visualization that expands JSON to columns dynamically in Custom Visuals Development Discussion

Custom visualization that expands JSON to columns dynamically

Re: Custom visualization that expands JSON to columns dynamically