Forum Discussion
Can I create a Table from a Matrix?
Hi! I want to create a new table related to the one I use as a database, and I want it just like a Matrix visual I already made. I'm just starting to use Power BI, and I don't know how to do this with DAX, so I was wondering if maybe I could make the table automatically from a Matrix. Do you know if this is possible?
For example I have a database of fruits and the days in a year when I ate any of those, so the matrix I created from that DB is basically a column with the name of the fruit not repeated and columns with the "count of fruit" every month in a year.
I could export the matrix as a csv and then import it, but that wouldn't link all the details of the database to number behind "count of fruit". For example it would be interesting to filter that number by other fields I have on my database like "Type of fruit" or "Fruit color" and so on,
Thank you for your time,
I am attentive to your comments,
Best regards,
Gabriela Sofía
Hi Anonymous ,
On PBI you don't need to create additional table to have filtering by other columns on your table in this caseType of fruit of fruit color.
If your database already have this columns you can create slicers, you can add the columns to the filters you can add additional columns to the matrix or other visuals and filter out the information on the matrix.
Check the documentation about slicers and filters to have an idea on how you can interact within your report, also check the interactions page for detail on how visuals interact between them.
If you need any further assistance please tell me.
Regards,
MFelix
6 Replies
Hi Anonymous ,
On PBI you don't need to create additional table to have filtering by other columns on your table in this caseType of fruit of fruit color.
If your database already have this columns you can create slicers, you can add the columns to the filters you can add additional columns to the matrix or other visuals and filter out the information on the matrix.
Check the documentation about slicers and filters to have an idea on how you can interact within your report, also check the interactions page for detail on how visuals interact between them.
If you need any further assistance please tell me.
Regards,
MFelix
Hi MFelix but what if I do a new table summarizing the database; if I make a visual of this table, could I filter it by the categories on the database?Hi Anonymous ,
You can add a slicer a filter on the visual or with the interactions between visuals, so this will make the filtering based on your database.
Regards,
MFelix