Forum Discussion

bdpr_95's avatar
bdpr_95
Helper IV
1 year ago
Solved

Performance Concerns with Manual Row-Level Table and SWITCH Function

Hi everyone, I’m working on a Power BI report where I needed to create a table visual with very specific rows. These rows don’t come from a data source, so I had to manually define them using a calc...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi bdpr_95 

    That’s a great point, and I understand your concern about the SWITCH logic still being present. To better assist your current setup and explore if we can streamline it differently maybe even eliminate the SWITCH entirely, I would  really appreciate if you could share a small sample of your dataset.

    Could you provide:

    • A few rows from your base table showing Column1, Column2, and Column3

    • A list or table of how you want the final visual to look (with expected values for Measure 1, 2, 3, etc.)

    This will help me tailor the solution specifically to your logic, and potentially offer a more scalable approach for the 36+ possibilities you're managing.
    How to provide sample data in the Power BI Forum - Microsoft Fabric Community