Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Excel formatting for use in Power Bi

Hi there,

 

I just finished the Microsoft course on edx.org. With the help from this course I made my first PowerBi dashboard. (a simple excel sheet). Within our organisation we use multiple excel sheet for our KPI's. I'm trying to create dashboards from one of the excelsheets, but I'm having a strugle to get any data at all.  Can someone help me? and get me up to speed in this? As you can see I have different KPI's and all with a different norm. Any help or direction is appreciated!

Need Help

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous what have you tried to do and what part are you struggling with exactly?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      In the KPI column I have set some KPI's I want to measure. I want to group these (like you can select with excel) and create a visualization. So I want e.g. Incident Mangement, and the data from this part of the sheet. Now I'm trying to delete the unessary fields. Beneath you'll find the one I created in excel. If you take the last chart. I have some of the results in column chart but I also want some into a line chart (combined). The exact figures of the line chart are standing to the right of the chart (0 to 5). And on the left I have the exact figures of the column charts (0 to 120).

       

      And in Power BI I have created (for change management) the following. (filtering the values which I need)

       

      But I'm not able to produce the Line chart. 

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Hi kstja0,

         

        Line and stacked column chart or Line and clustered column chart can meet your requirement.

         

        Regards,

        Jimmy Tao