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
    DataNinja777
    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,

     

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
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,

 

  • adityah's avatar
    adityah
    Frequent Visitor
    2 years ago

    Thanks DataNinja777 !!! This works but I think a DAX solution might be better since when I add a 3rd column to the left side it becomes slightly ugly