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 matrix to show the rest of the values. Is it possible for someone to give me some advice on how this should be done?

For example:

Column X          

NY                     

LA                      

London

Mexico

Viena 

Prague

 

1st matrix -> NY LA LONDON, 2nd matrix -> MEXICO, VIENA, PRAGUE

7 Replies

  • 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?

      • 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.