Forum Discussion

HanaOkugic's avatar
HanaOkugic
Regular Visitor
8 months ago
Solved

Showing the same parameter multiple times in a Table visual

Hi everyone, I could really use some help. I don’t think this should be too complicated, but I’ve gotten completely tangled up. Here’s the situation: I have a simple Excel table with my data (DATA)...
  • Nabha-Ahmed's avatar
    8 months ago

    Hi HanaOkugic 

    1️⃣ Add a “Helper Column” to make duplicates unique

    Power BI does not allow identical rows to appear twice if there’s no unique identifier.

    Solution: create a new column in your table (Power Query or DAX) to make each row unique.


    Power Query approach

    1. Go to Transform Data → Power Query.


    2. Add an Index Column:

    Home → Add Column → Index Column → From 1

     

    3. Add a Custom Column that combines your parameter with the index:

     

    UniqueParameter = [Parameter] & " - " & Number.ToText([Index])

    4. Load data back to Power BI.


    5. Use UniqueParameter in the Table visual — now duplicates will appear as separate rows.

     


    ---

    2️⃣ Use DAX to create a “duplicated table”

    If you want to repeat certain values programmatically:

    DuplicatedTable =
    UNION(
    SELECTCOLUMNS(DATA, "Parameter", DATA[Parameter], "Value", DATA[Value]),
    SELECTCOLUMNS(
    FILTER(DATA, DATA[Parameter] IN {"Apple","Peach"}),
    "Parameter", DATA[Parameter],
    "Value", DATA[Value]
    )
    )

    This creates a table with Apple and Peach repeated.

    Use DuplicatedTable in your Table visual.

    If this solution helped you, please mark it as the accepted answer so it can help others as well.

    Best regards