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...
Need Help
Show and Tell
Tips and Tricks
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...