Forum Discussion
Visual Creation help please.
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% |
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#M1425151If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl
5 Replies
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.
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#M1425151If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl
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.
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.
-
