Forum Discussion
Matrix/Table/Other??
Hi All,
New to the group. I'm looking for help on how I can recreate a table I have in excel in Power BI. I've tried both the Matrix and Table visuals in Power BI, but I cant figure out how to format it to mee my needs. What I'm looking to do is have a list of clients (rows) with specific metrics (columns) and be able to view them month over month.
Here's an example of what I'm looking for:
| Jan-24 | Feb-24 | |||||
| Client | SLA% | ABN% | Yield % | SLA% | ABN% | Yield % |
| Albuquerque, NM | 100% | 0% | 56% | 100% | 42% | 67% |
| Denver, CO | 30% | 41% | 64% | 25% | 52% | 70% |
Does anyone know how this can be done?
The closest I've come, looks like this, by using the 'table' visual to get my list of clients and the metrics.....
| Client | SLA% | ABN% | Yield % |
| Albuquerque, NM | 100% | 0% | 56% |
| Denver, CO | 30% | 41% | 64% |
........But I still need the ability to add/group more months of data like the chart at the top.
Any suggestions would be greatly appreciated.
Thanks,
Cheque
2 Replies
When you come from Excel you are used to wide tables with many columns. Power BI is different, it works best with narrow, long tables. There is a process step called "Unpivot" that will help you to transform the Excel data into usable format.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Cheque
Please try to use the 'matrix' visual.
Here I create a set of sample:
Then add a matrix visual:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
