Matrix or other visual?

[Sylvain74]

Hi,

I am trying to achieve below visual output with a matrix but I am not sure it's right visual...or maybe I don't setup properly the different properties to achieve it.

The idea is to group first by currency then by bank and then under each bank I should display operator abbreviation, date, invoice number.... and of course amount and balance.

In SSRS it would be quite easy to achieve it via a simple table and some groups but here in Power BI, I don't find.

Can you please help me?

Thanks.

[v-jianboli-msft]

Hi @Sylvain74 ,

Based on your description, I have created a simple sample:

Please try:

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sylvain74]

Hi Jianbo,

Thank you very much for your answer, however this is not exactly what I am looking for.

I already achieved to produce a layout like the one you proposed but as you can see in my print-screen the group headers are displayed different and more important there are some fields/columns which are not summable data which are in between text columns...

As I understand is that Power BI Matrix only allows to have summarizable data as data value and really behaves like a pivot table.

That's why I was wondering if there are any tricks to get this output or if I should use another visual...