Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Display a Text Table visualization in a grouped by format

Hi All,

 

I am new to Power BI. Would like to know how to display a Text Table visualization in grouped by format like below example (By default I am getting the current output, need help to get expected output) :

 

 

Thanks

Need Help

3 Replies

  • mpraka's avatar
    mpraka
    Advocate II
    3 years ago

    To group like the you have to use "Matrix" visual from the visualization pane.

     

    Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    As far as I know, matrix visual is a good choice to achieve your goal.

    For referecne: Create a matrix visual in Power BI - Power BI | Microsoft Learn

    I think you still need to transform your visual in Format after you create a matrix.

    1. Turn off "Stepped layout"

    2. Turn on "Horizontal gridlines" and "Vertical gridlines". Then change the line colors the same as "Border".

     

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks, it works as expected