cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GabrielaSofia Frequent Visitor
Frequent Visitor

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



 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Can I create a Table from a Matrix?

Hi @GabrielaSofia ,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




GabrielaSofia Frequent Visitor
Frequent Visitor

Re: Can I create a Table from a Matrix?

I finally got it, I made a measure:

MeasureAVG = count(BD[Fruits])/DISTINCTCOUNT(BD[Fruits])

and then I put that measure on a Line chart in Values and on Legend I put the Color and on Axis I put the months,

Best regards,

6 REPLIES 6
Super User
Super User

Re: Can I create a Table from a Matrix?

Hi @GabrielaSofia ,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




GabrielaSofia Frequent Visitor
Frequent Visitor

Re: Can I create a Table from a Matrix?


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?

Super User
Super User

Re: Can I create a Table from a Matrix?

Hi @GabrielaSofia ,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




GabrielaSofia Frequent Visitor
Frequent Visitor

Re: Can I create a Table from a Matrix?

I see... so I wouldn't need to create all those fields to filter the data of the new table.
Well, the problem is, I still can't solve the initial problem. I mean, I made the matrix in the first place because I need a calculated value from that matrix and a visual from that calculation.

To give a little more context about this, I'm gonna make it on excel, for I don't know how to on PBI. Here's a table of the count of fruit by month and by category of color (r=red, g=green, b=blue).

Tabla frutas.png
So, from this blessed table (the famous matrix on PBI) I calculate the average on every column to make a chart of the average of the times a fruit was eaten by month and by category, like this
:
tabla frutas promedio.png
So finally the question is: how can I make this chart on PBI?

Best Regards,
Thank you for your time and your patience @MFelix 
I will be attentive to your comments,
Gabriela

Super User
Super User

Re: Can I create a Table from a Matrix?

Hi @GabrielaSofia,

Can you confirm the your table is like this:

Fruit - Colour - Month


Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




GabrielaSofia Frequent Visitor
Frequent Visitor

Re: Can I create a Table from a Matrix?

I finally got it, I made a measure:

MeasureAVG = count(BD[Fruits])/DISTINCTCOUNT(BD[Fruits])

and then I put that measure on a Line chart in Values and on Legend I put the Color and on Axis I put the months,

Best regards,

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 266 members 3,053 guests
Please welcome our newest community members: