Forum Discussion

TheDon's avatar
TheDon
Regular Visitor
1 year ago
Solved

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...
  • Ritaf1983's avatar
    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#M1425151

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