Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 months ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    6 months ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 months ago

danextian Oops! I missed that I had done transformation. To help me on this, I have shared the sample data here 

Summary - is the table which would be driving table

Details- is the table which has JSON values in a column
Please let me knoe if you need any clarification.

danextian's avatar
danextian
Super User
6 months ago

The link is the same as initially posted

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 months ago

    This will definitely work.

    You dont need all these tables danextian 

    Just refer to the two csv files I shared with you, and then you can just start in a fresh new pbix file.

    • danextian's avatar
      danextian
      Super User
      6 months ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 months ago

        Thanks a lot danextian 
        It seems to be working and the only thing I want to check with you, in my actual data the details table has 1.3 Lakhs rows which further grew up to 39 Lakhs after the transformation.
        Row count doesn't seem to be a big problem, the part which I am concerned of is, the transfomation step took almost 1.5 hrs to load the data after transformation.
        Is this expected or can we improve on this?