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....
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
      Icon for Community Support rankCommunity 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