Forum Discussion
Visual Creation help please.
- 1 year ago
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,
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.