Power BI - Excel To Power BI - Report Style Help Needed

[Pfin]

I'm trying to recreate a report in Power BI that has long lived in Excel for YEARS where the user can basically create the format that has been used.  Any input on how to provide this same information on a one pager to provide same info would be greatly appreciated.

In short, there is an X-axis (Segment/Size) and a Y-axis (Manufacturer).  I need the report to place the data points (Model, Price, and Available Date) in the cells.  This is a living table/report where current values can be updated, records removed, records added.

It doesn't have to be this exact look / feel, but it needs to be easy to read similar to this and displayed on one page and printable. I have attached the example data and report below.

Data Table

Manufacturer	Segment	Model	Price	Available Date
Chevrolet	Mini	Spark	12000	9/30/2025
Chevrolet	Mini	Bolt	9000	2/28/2026
Chevrolet	Small	Trax	22000	6/30/2025
Chevrolet	Medium	Malibu	24000	1/31/2026
Chevrolet	Medium	Blazer	27000	3/31/2026
Ford	Small	Fiesta	12000	12/31/2025
Ford	Small	Focus	10000	8/31/2025
Ford	Large	Taurus	19000	4/30/2025
Kia	Mini	Picanto	10000	8/31/2025
Kia	Small	Rio	14000	11/30/2025
Kia	Large	Cadenza	28000	7/31/2025

Report

[Ashish_Mathur]

Hi,

This M code works as well

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Manufacturer", type text}, {"Segment", type text}, {"Model", type text}, {"Price", Int64.Type}, {"Available Date", type date}}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Changed Type", {{"Price", type text}, {"Available Date", type text}}, "en-IN"),{"Model", "Price", "Available Date"},Combiner.CombineTextByDelimiter("#(lf)", QuoteStyle.None),"Merged"),
    #"Grouped Rows" = Table.Group(#"Merged Columns", {"Manufacturer", "Segment"}, {{"Count", each Text.Combine(_[Merged],"#(lf)-----------------#(lf)")}}),
    #"Pivoted Column" = Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[Segment]), "Segment", "Count")
in
    #"Pivoted Column"

Hope this helps.

[Pfin]

This is fantastic as well!  Thank you for the reply and help!

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark that reply as Answer.

[Fowmy · Accepted solution]

@Pfin 

Use this measure:

Data = 

CONCATENATEX(
    Table02,
    Table02[Model] & UNICHAR(10) &
    Table02[Price] & UNICHAR(10) &
    Table02[Available Date] & UNICHAR(10), "-----------" & UNICHAR(10)
)

[Pfin]

Wow!  This is fantastic!  Thank you!