Create a visual to show the current month's sales vs last month's sales | Power-Bi Tutorial 2023

preview_player
Показать описание

Create two measures: one for the current month's sales and one for the last month's sales. You can use the following DAX formulas for these measures:
Create a visual to display the two measures. You can use any visual that supports two values, such as a bar chart, column chart, or line chart.

Set the visual's Axis property to the Date column.

Set the visual's Values property to the two measures that you created in step 1.

For example, you could create a column chart with the Date column on the Axis and the CurrentMonthSales and LastMonthSales measures on the Values. This would create a chart that shows the current month's sales vs last month's sales for each date in the Date column.

You can also use conditional formatting to highlight the differences between the current month's sales and last month's sales. For example, you could format the columns in the chart to be different colors depending on whether the current month's sales are higher or lower than last month's sales.
Рекомендации по теме
Комментарии
Автор

11. Create a map visual and use the drill down to show detailed information for each country by state. (For detailed information you can use the region slicer).

piyushjaiswal
Автор

18. Insert the scroller custom visual and add it to the report page referring to the country and profit column.

Naturelover
Автор

16. Create a week column based on the order date from the global superstore data.
e.g. required output “Week-5”

piyushjaiswal
Автор

19. Create a shared workspace and add the organization members to the workspace then publish the report.

piyushjaiswal
Автор

Create week column based on the order date from the global superstore data. Eg required output “week-5”

bhuvanareddy
Автор

15. Create a new summarize table with selected columns (region, country, sum of sales) from the global superstore and filter the region based on the given conditions, Central Asia, North, South & East.

piyushjaiswal
Автор

Please create a video on this
Create a shared workspace and add the organization members to the workspace then publish the report.

komalparab
Автор

please make the video on above topic which I have shared in comments

piyushjaiswal
Автор

8. Add all 3 tables from the model and create a table to show the detailed information for each day wise the sum of order quantity, shipped quantity, and delivered quantity. Kindly use a card visual to show the difference between the total order quantity and the shipped quantity,
the 2nd difference between total order quantity and delivered quantity, using quick measure.

vedantghatage
Автор

10. Refer to question no. 6! After importing all the 3 years of the data, kindly add the custom column of specific year data for e.g. (if you have imported the data for the year 2023, please create a new column called year and add 2023 for each row).

piyushjaiswal
Автор

which tool or visualisation you use for adding country name in dash bord its change automatically when the data change as per the slicer change

jjxlntu
Автор

please help for all the below questions

rushalishelke
Автор

18. Insert the scroller custom visual and add it to the report page referring to the country and profit column.

piyushjaiswal