Forum Discussion

Sylvain74's avatar
Sylvain74
Helper III
3 years ago

Matrix or other visual?

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.

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    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's avatar
      Sylvain74
      Helper III
      3 years ago

      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...