Forum Discussion

magyar's avatar
magyar
Frequent Visitor
9 years ago

Months in fields/columns in Table visuals

It would be easier if it was possible to show screenshots or attach files...or is that possible?

 

Anyway, I would like to transform this:

 

Sales    Months  Shop

$1          Jan          A

$2          Feb         A

 

to this in a Table or Matrix Visual:

 

Shop   Jan     Feb   

A         $1       $2

 

Any hint or ideas are very much appreciated.

 

David

 

Need Help

7 Replies

  • s15's avatar
    s15
    Helper III
    9 years ago

    Hi magyar

     

    You can pivot the Month column. Do the following things:

    Step 1: Click table icon on the left panel. Select Edit Queries > Edit Queries.

     

     

    Step 2: When the Query Editor opens, click Transform tab on the Ribbon. Click Month column. Click Pivot Column.

     

     

    Step 3: Select sale under Values Column. Click OK

     

     

    Step 4: Click Home tab. Click Close and Apply to make changes.

     

     

    By the way, you can attach the photo by click photo icon..

     

     

    If this is helpful please accept as a solution. Thank you.

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Hey,

     

    as you can see, what you are looking for can be achieved using the Matrix-Visual (so it's possible to attach screenshots to the post)

     

     

    Here you can find the example pbix, as you can see it's not possible to attach any other files besides images, txt-, xlsx-, or pbix-files have to be shared using a link.

     

    Hope this helps

    • magyar's avatar
      magyar
      Frequent Visitor
      9 years ago

      Thanks guys. I have tried what you have suggested before but it doesnt seem to work. Please see attched pictures:

       

      This is before pivoting the date field...

       

       

      and this is after. As you can see it does the job in terms of pivoting the table on the date field but the values for "OverallStatus" have changed from text to 1s and 0s. Not sure why?

       

       

       

      Thanks for trying to help.

       

      David

      • s15's avatar
        s15
        Helper III
        9 years ago

        It would be better if you could give the dataset. You asked another dataset which showed Month only. Now your dataset is totally different. Please share your expected outcome in Excel file.

         

        Thank you.