Matrix/Table/Other??

[Cheque]

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

[Anonymous]

Hi @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.

[lbendlin]

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-...

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/1447...