Unable to configure a Power BI Matrix as in a Excel Pivot Table

[Anonymous]

Hi eveyone!

I'm having some trouble in reproducing on Power BI a pivot table that is easily done on Excel. As shown below, I want to display sum of cost for each date (in the format dd/mm/yyyy) and for each supplier (columns).

I'm having two problems when I try to display a table similar to that one on Power BI:

1. The suppliers are being shown as unique values. Because of that, instead of 15 columns, PBI shows thousands of them [A]. It seems like Power BI has classified that field as a primary key, and even put a "ID" icon beside the name of the field [B].

2. I can't get each date to be shown in one single line - the dates are being repeatedily, as if the time is still being considered [C]. I've already changed the Data Type to date instead of datetime and the format to dd/mm/aaaa [D]. I know I could group by year, months and then days, but if its possible, I'd like to do as in the table shown above.

Could you guys help me?

Thanks in advance!

[Anonymous]

Hi @Anonymous ,

Looks like a relationship issue.

What are the relationships between these tables?

Different relationships between tables could return different results.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships .

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand 

It's better to share the data model or at least the screenshot about the relationships between tables.

Refer this topic about How-to-Get-Your-Question-Answered-Quickly .

Best Regards,

Jay

[Anonymous]

Hi @Anonymous!

All the data comes from one single table. So, there is no relationship that could be the source of the problem.

Regards,

Thiago

[Anonymous]

Hi @Anonymous ,

Please share some sample data so that we could reproduce the scenario.

Best Regards,

Jay