Forum Discussion
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...
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 😀
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,
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
