Forum Discussion
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....
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
Community Support
Community SupportHi， 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