Forum Discussion

adityah's avatar
adityah
Frequent Visitor
2 years ago
Solved

Summarize table by Year

Hi Guys,   Sorry if this question seems noobish. I have the following shaped data    policy number product_code lob_description Date GWP x1 O MARINE 1/1/2024 20 x2 A HULL 1/1/...
  • DataNinja777's avatar
    2 years ago

    Hi adityah ,

    You can achieve your desired output by using the Matrix visual. Start by expanding the row headers using the double arrow icon highlighted in green, then set the layout to 'Outline' as shown below.

     

    I have attached an example pbix file.  

    Best regards,