Visual Creation help please.

[TheDon]

Hello all,

I am new to the forums and also new to Power BI development. I have a business case where I need to try to duplicate what I have in Excel and make it part of an app. What I'm trying to do is duplicate what I have below as best as possible. What I'm having trouble is the second. where it breaks it out by 3 months, 6 months and 12 months in the same matrix. I would really appreciate any guidance.

	R 12 Month	3 Month	6 Month	12 Month	2 Year
Category	Total Spend	$Δ	%Δ	$Δ	%Δ	$Δ	%Δ	$Δ	%Δ (CAGR)
Cardiology	$              51.93	$            (2.09)	-4%	$    (1.75)	-3%	$    (1.65)	-3%	$  (1.46)	-1%
Oncology	$              80.15	$               2.62	3%	$       1.65	2%	$       1.35	2%	$     8.30	6%
MSK	$              74.77	$            (7.69)	-10%	$    (5.61)	-7%	$    (3.84)	-5%	$  (5.96)	-4%
Kidney	$                 9.70	$               1.14	13%	$       0.75	8%	$       0.32	3%	$     0.19	1%
Gastro	$              53.34	$            (1.93)	-4%	$    (0.63)	-1%	$       0.54	1%	$     1.66	2%
All Other	$            362.91	$            15.28	4%	$    15.60	4%	$    12.17	3%	$  20.65	3%
Total	$            632.79	$               7.33	1.2%	$    10.01	1.6%	$       8.88	1.4%	$  23.38	1.9%

[Ritaf1983 · Accepted solution]

Hi @TheDon 

Unlike Excel, Power BI doesn't treat visuals as individual cells, so recreating a matrix like the one you have—especially with multiple time-based breakdowns in a single matrix—isn’t straightforward using standard matrix visuals.

However, there are workarounds using dynamic measures or calculated groups (field parameters). These techniques allow you to control what appears in the matrix dynamically.

This thread discusses a very similar challenge (although the question there is about vertical customization, the logic is the same for horizontal layouts):
https://community.fabric.microsoft.com/t5/Desktop/How-to-combine-to-matrix-visuals/m-p/4785435#M1425...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl

[v-aatheeque]

Hi @TheDon 

Just following up on your earlier query regarding creating a matrix with 3-month, 6-month, and 12-month breakdowns in the same visual.

As mentioned previously, Power BI doesn’t allow such layouts directly within a single standard matrix. The recommended approaches are:

• Dynamic measures

• Calculated groups / field parameters

These techniques let you control what appears in the matrix dynamically and achieve a similar effect to your Excel layout.
A related example was shared in the earlier thread link for reference.

Please let us know if you need further clarification on the setup steps.

[v-aatheeque]

Hi @TheDon 

Following up on your question about showing 3-month, 6-month, and 12-month breakdowns in one matrix visual as mentioned earlier, Power BI doesn’t natively support this in a single standard matrix.

Suggested options include using dynamic measures or calculated groups/field parameters to control the display dynamically. An example was shared in the previous thread for reference.

Let us know if you’d like more details on setting this up.

[v-aatheeque]

Hi @TheDon 

Just following up were you able to try the suggested approaches (dynamic measures or field parameters) to achieve the matrix layout you’re aiming for?

If the solution provided by @Ritaf1983 helped,These options (dynamic measures or calculated groups/field parameters) allow you to control the display dynamically, and an example was shared in the previous thread for reference.

Let us know if you’d like more details,  we look forward to your response.

[Ashish_Mathur]

Hi,

Cannot undderstand your pasted data.  Share the download link of the MS Excel file with your formulas already written there.  I will translate those formulas into DAX measures.