Forum Discussion

okusai3000's avatar
okusai3000
Helper IV
6 years ago

Cannot get a Fixed Row Number on a Matrix

Hello everyone,

 

I have been strugling for ages to get a FIXED row number value in a matrix. I already know how to get it on the Power Query Editor, but of course that it's not enough to get it working on a matrix.

 

I attached you an example of what I'm talking about. It's the first column what Im looking for.

 

 

What can I do?

 

Thanks!

 

Need Help

4 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    6 years ago

    In such issue I personally follow these steps:

     

    1. Create a Custom Column indicating by Country - viz., USA -1 , UK - 2 and so on. 

    2. I can use that column in to row values of matrix so that I have row number is fixed

     

    Did you try that ?

    - Vijay Perepa

    • okusai3000's avatar
      okusai3000
      Helper IV
      6 years ago

      Sorry, I don't understand you....

       

      If you are saying that USA will have the 1, and UK  the 2, and so on, they will be related to each other.

       

      The column needs to be fixed no matter what filter I use....