Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix Stepped Layout first column show values all rows

Hi all,   I have the following data loading into my Power BI file:                         I have disabled the stepped layout, but how can I make it possible to duplicate the v...
Need Help
  • jaideepnema's avatar
    jaideepnema
    4 years ago

    Anonymous ,

    Have you tried creating two separate measures something like this

    Location 1=calculate(<Measure Name>,Location="Location 1")

    Location 2=calculate(<Measure Name>,Location="Location 2")

     

    Please accept this as a solution if your question has been answered !!

    Appreciate a Kudos ğŸ˜€

     

  • philouduv's avatar
    philouduv
    4 years ago

    Hey Anonymous, 

    My bad, select the location column, go on transform and click on pivot column, select value as Values column ( for you it would be Count)



    Best regards,

     




philouduv's avatar
philouduv
Resolver III
4 years ago

Hey Anonymous,

Go on power query and select the 2 column: location 1 and 2 :

Then right click and unpivot column : 


Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi philouduv,

     

    Unfortunately I want to have it in the layout how you displayed it in the first image.

    Below is how the data will be loaded into Power Query

    • philouduv's avatar
      philouduv
      Resolver III
      4 years ago

      Hey Anonymous, 

      My bad, select the location column, go on transform and click on pivot column, select value as Values column ( for you it would be Count)



      Best regards,

       




      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        philouduv thank you! This is exactly what I needed, and with this way I do not need to create several measures.