Data Presentation - Mutiple

Here’s how you can present the data for Location and Account Name in Power BI:

1. Presenting Location Data in a Donut Chart

A donut chart is a great way to show the breakup of users by Location. Here’s how you can set it up:

1. Load Data:

   • Ensure your data is loaded into Power BI with columns for Location, User Name, Account Name, and Course Title.

2. Create a Donut Chart:

   • Go to the Visualizations pane and select the Donut Chart.

3. Configure the Donut Chart:

   • Drag the Location field to the Legend area.
   • Drag the User Name field (or any field you want to use for counting) to the Values area. Make sure it’s set to Count to count the number of users for each location.

4. Customize the Donut Chart:

   • Use the Format pane to adjust the appearance of the donut chart as needed. You can adjust colors, labels, and other visual elements to make the chart clear and appealing.

2. Presenting Account Name with User Name

To show how many users are from each Account Name, you can use a bar chart or a matrix. Here’s how to do it with both:

Option 1: Bar Chart

1. Create a Bar Chart:

   • Go to the Visualizations pane and select the Bar Chart.

2. Configure the Bar Chart:

   • Drag the Account Name field to the Axis area.
   • Drag the User Name field to the Values area and ensure it is set to Count.

3. Customize the Bar Chart:

   • Use the Format pane to adjust the chart’s appearance, labels, and colors.

Option 2: Matrix

1. Create a Matrix:

   • Go to the Visualizations pane and select the Matrix.

2. Configure the Matrix:

   • Drag the Account Name field to the Rows area.
   • Drag the User Name field to the Values area and ensure it is set to Count.
   • Optionally, you can also drag Location or Course Title to the Columns area if you want to further break down the data.

3. Customize the Matrix:

   • Adjust formatting in the Format pane to enhance readability and presentation.