Forum Discussion

simona0808's avatar
simona0808
Helper I
4 years ago

2 separate matrices displaying different values from one table

Hi everyone! I am trying to create 2 matrices that are populated with data from the same table [Navigation]. The problem is I want matrix1 to show the first 5 values from that column and in the next...
lbendlin's avatar
lbendlin
Super User
4 years ago

Power BI has no idea what "the first 5 values " means unless you provide some sort criteria, or an index column.  Does your source data have one of these?

  • simona0808's avatar
    simona0808
    Helper I
    4 years ago

    My table has a rowID column

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Please provide sanitized sample data that fully covers your issue.

      Please show the expected outcome based on the sample data you provided.

      • simona0808's avatar
        simona0808
        Helper I
        4 years ago

        Sent you a private message. I will publish the solution here once I have a result