Step-by-Step Guide to Create a Date Card in Power BI

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.

Example

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 "Order Date" 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

Try Following Formatting Options

1. Prepare a date card showing "Latest Order Date"

Go to "Build" pane - under build pane go to "Fields" - Right Click on the "Order date" - a drop down will appear - select "Latest" option from the dropdown - you will have the latest order date displayed in the date card

2. Prepare a table below card with columns - Order date, sales, profit

go to "Build" pane - select "Table" visual - drag "Order date" to "Columns" - now you will have order date with year, quarter, months and date in different column - to bring them all together - Right click on the order date under "Columns" in "Build" Pane - a dropdown will appear - click on "Date hierarchy" - now you will have year, quarter, months and date under one column - drag "Profit" to "Columns"  - drag "Sales" to "Columns"

3. Prepare a card showing date on which highest sales were created 

Drag the "Order Date" 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 "Order Date" 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 date in the Date Card on which highest sales was recorded   

4. Prepare a card showing date on which highest profit were created  

Drag the "Order Date" 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 "Order Date" 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 date in the Date Card on which highest profit was recorded