Forum Discussion
Dynamic Column Headers in Table Visual Based on JSON Data
I have a table visual on a report page with multiple columns, one of which is QC ID. In the data model, QC ID is related to another fact table that contains a column in JSON format. This JSON column...
In the image below, you'll need to add an index column to uniquely identify each row values in matrix are always aggregated.
Please see the attached pbix.
Thigns to bear in mind when using matrix:
Sorting by row category must respect the hierarchy. Lower level headers are sorted within the context of hte upper level headers.
Column headers resulting from using a dimension cannot be sorted individualy like you can with a table.
And, unpivoting is done in the query editor so pbix alone is not enough as the data needs to be transformed.
The link is the same as initially posted
In the image below, you'll need to add an index column to uniquely identify each row values in matrix are always aggregated.
Please see the attached pbix.