1. Open Power BI Desktop:
Launch Power BI Desktop on your computer.
2. Load Your Data:
Click on Home > Get Data.
Choose your data source (e.g., Excel, SQL Server, etc.) and load your data into Power BI.
3. Select the Data for the Card:
In the "Fields Pane", select the data fields you want to visualize. For example, you might choose Profit, Quantity and sales.
4. Insert a Card:
Go to the "Build" pane on the right side.
Click on the Card icon.
5. Configure the Card:
Drag the desired fields to the appropriate areas in the Build pane
6. Customize the Card:
Use the "Format" pane to customize the appearance of your chart. You can change colors, add data labels, adjust axis titles, and more.
7. Save Your Report:
Once you're satisfied with your chart, save your report by clicking on File > Save As.
Load the Sales Data:
Import your sales data into Power BI.
Create the Card:
Select the "Card" from the "Build" pane.
Add Fields:
Drag the "Sales" field to the "Fields"
Customize:
Use the "Format" pane to adjust the chart's appearance.
By following these steps, you should be able to create a "Chart" in Power BI that effectively visualizes your data
1. Prepare a card showing Profit
Drag the "Profit" field to the "Fields" - you will be able to see profit value in the card.
2. Prepare a card showing Quantity
Drag the "Quantity" field to the "Fields" - you will be able to see Quantity value in the card.
3. Make the cards dynamic showing values for sales, profit and quantity for different states (Include Maps Visual)
Prepare three separate cards for "Profit", "Sales" and "Quantity" - create a simple map below the cards by selecting "Map" from the "Build" pane - drag "State" to "Location" and "Sales" to "Bubble Size" - click on any state on map and you will be able to see the profit, sales and quantity of that particular state
4. Make the cards dynamic showing values for sales, profit and quantity for different subcategories (Include Table Visual)
Prepare three separate cards for "Profit", "Sales" and "Quantity" - create a simple table below the cards by selecting "Table" from the "Build" pane - drag "Subcategory" to "Columns" , "Sales" to "Columns", "Profit" to "Columns", "Quantity" to "Columns" - click on any subcategory in table and you will be able to see the profit, sales and quantity of that particular subcategory