Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Split a dataset into multiple tables automatically based on the column

I have the following dataset and i want so split it into multiple tables where the number of multiple tables are equal to the number of different sub-categories that are included in "Caption" Column.  Ideally, i would like to split it automatically.

 

 

 

Output:

 

1st table

Intercept Intercept

 

2nd table

Driver Age 18--21

Driver Age 22--24

Driver Age 25--30

Driver Age 31--50

Driver Age 51--70

Driver Age 71+

 

3rd table

etc 

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I doubt you can split and create tables. You may create tables and filter data as per need

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak 

       

      I have used a DAX expression using

      Table_District = FILTER('Dataset'[Caption] = "District").

       

      This has the limitation that if the District changes to District1 the following table will not be created

      Generally, I would like to create the tables automatically.

      How i can do that? 

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi， Anonymous 

        Currently PowerBI does not support automatic splitting of the table by the row value of a certain column.

        If the District changes to District1, you need to use another  Dax expression

        Table_District1 =
FILTER ( 'Dataset', 'Dataset'[Caption] = "District1" )

        For your requirement , you can submit it as an idea on Power BI Ideas forum and add your comments there to make this feature coming sooner. 

         

        Best Regards,
        Community Support Team _ Eason