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 Subcategory.
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 "Subcategory" 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 highest sales in different category
Drag the "Subcategory" field to the "Fields" - open "Filter" pane - you will see three sections in filter pane named "1. Filters on this visual", "2. Filters on this page", "3. Filters on all page" - you will find an option named "Add data fields here" under each of the above sections - drag and drop "Subcategory" from the "Data" pane below the option "Add data fields here" in the first section named "Filters on this visual" - a dropdown list will appear - in the options "Filter type" select "Top N" - in the options "Show items" select "Top" - besides this option there is a blank box - type "1" in the blank box - drag "Sales" from the "Data" pane and drop under the option "By value" - click on "Apply filter" - you will be able to see the name of "Category" in the Text Box which has highest sales
2. Prepare a card showing highest profit in different category
Drag the "Subcategory" field to the "Fields" - open "Filter" pane - you will see three sections in filter pane named "1. Filters on this visual", "2. Filters on this page", "3. Filters on all page" - you will find an option named "Add data fields here" under each of the above sections - drag and drop "Subcategory" from the "Data" pane below the option "Add data fields here" in the first section named "Filters on this visual" - a dropdown list will appear - in the options "Filter type" select "Top N" - in the options "Show items" select "Top" - besides this option there is a blank box - type "1" in the blank box - drag "Profit" from the "Data" pane and drop under the option "By value" - click on "Apply filter" - you will be able to see the name of "Category" in the Text Box which has highest sales
3. Prepare a card showing highest quantity in different category
Drag the "Subcategory" field to the "Fields" - open "Filter" pane - you will see three sections in filter pane named "1. Filters on this visual", "2. Filters on this page", "3. Filters on all page" - you will find an option named "Add data fields here" under each of the above sections - drag and drop "Subcategory" from the "Data" pane below the option "Add data fields here" in the first section named "Filters on this visual" - a dropdown list will appear - in the options "Filter type" select "Top N" - in the options "Show items" select "Top" - besides this option there is a blank box - type "1" in the blank box - drag "Quantity" from the "Data" pane and drop under the option "By value" - click on "Apply filter" - you will be able to see the name of "Category" in the Text Box which has highest sales
4. Link the above prepared visual cards with a column chart showing category wise highest selling, most profitable and most ordered
create a simple column chart - drag "Category" to "X-Axis" - drag "Sales" to "Y - axis" - now click on columns to get values for highest selling, most profitable and most ordered items