Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Put data from a sharepoint flat file into "dimensions"

    Posted Dec 17, 2021 12:33 PM
    Hi,

    We have a sharepoint/power app application where you have to enter data. Most of the things goes fine, but in the form we have around twenty fields, which you must mark. for example a field suicide (A), run away (B), agression (C) etc. Now i want to report how much agression there was, suicide, run away and so on.

    so you need togo from a,b,c to
    a
    b
    c

    Is there a way to reorder teh specific field through a direct connection form sharepoint into powerbi? Or must is export the data from sharepoint and translate in an other way?
    I now got the picture above, but i need the picture at the bottom.

    Thanks


    ------------------------------
    Fred Baltus
    ICT Manager
    ------------------------------


  • 2.  RE: Put data from a sharepoint flat file into "dimensions"

    Top Contributor
    Posted Dec 20, 2021 08:14 AM
    So you need to switch a column chart to a bar chart or am I missing a more detailed question? If it is switching Bar to column, there are two different chart visuals in power bi that are for both chart types. Trying using the one that is going horizontal in the thumbnail

    ------------------------------
    Sam Duval
    Data Quality Analyst
    Element Financial
    Indianapolis IN
    ------------------------------



  • 3.  RE: Put data from a sharepoint flat file into "dimensions"

    Posted Dec 24, 2021 02:52 AM
    Hi Fred,
    It is not entirely clear to me how your data is arranged in SharePoint.  Do you have separate columns A, B & C with Yes/No entry in each?
    If this is the case, you should consider unpivoting the table in Power Query, so that you end up with a column called, say "Data Category" (Options being A, B or C) and another True/False column.
    I hope this helps.

    ------------------------------
    Kevin Mooney
    Moog Components Group Ltd
    Tewkesbury
    542-552-2011
    ------------------------------