Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create View from existing table

Hi,   I´m new to Power Bi and i need some help, so I hope you can help me.  I have a table which looks like that: Juni Juli Aug Sept Okt Nov Dez x x x x x x x x 1 1 1 1 0 0 ...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous - So if that is your source table, generally you would want to unpivot those columns in Power Query. Then things should be pretty easy.

  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    1. Select all of your column and use Unpivot columns in power query editor, close and apply it.

    2. Put the new fields in a matrix visual, set the value field as count of values to get the expected result:

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

1. Select all of your column and use Unpivot columns in power query editor, close and apply it.

2. Put the new fields in a matrix visual, set the value field as count of values to get the expected result:

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you, I´m gonna try it! 🙂