Forum Discussion

dmoney7612's avatar
dmoney7612
Helper II
5 years ago

Matrix exporting question

When I export the data from the below matrix to Excel, the rankings all appear as "1" in the file. Is there a way to work around this issue? I noticed this isn't a problem when exporting from the tab...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

dmoney7612 How are you exporting, from the Desktop export to CSV file or in the Service? I tried replicating this but was not able to do so in the Desktop.

dmoney7612's avatar
dmoney7612
Helper II
5 years ago

Greg_Deckler Yes, desktop to CSV. I'm thinking it's an issue with the matrix format. Rankings appear fine when I export a table visual. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    dmoney7612 Hmm, what version of the Desktop are you on? I can upload my test version if you think it might help.

    • dmoney7612's avatar
      dmoney7612
      Helper II
      5 years ago

      Greg_Deckler Version: 2.93.641.0. Sure, send it on over.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        dmoney7612 OK, well same version I am on. I have attached the PBIX below signature. You want the matrix visual in the lower left of the page. Measure 3 is the ranking measure.