Forum Discussion
Power BI - Excel To Power BI - Report Style Help Needed
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
5 Replies
Wow! This is fantastic! Thank you!
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.
This is fantastic as well! Thank you for the reply and help!
You are welcome. If my previous reply helped, please mark that reply as Answer.
