What Is Daily profit KPI?
1. Drag Order Date into columns and Drill Down to months, and remove the Quarter from the columns. Only Keep YEAR and MONTH.
2. Drag Order Date into Rows. And select the Measure as Count Distinct.
3. Now I am going to calculate the Daily Profit KPI.
4. In analysis, window go to create option and select Create calculated field. and name it as Daily profit KPI.
5. And give the calculation as shown below.
6. Now drag that Daily Profit KPI into Rows, and Convert it into Discreet.
7. Drag Daily Profit KPI into colour self at marks card level.
8. Then visualization will split into multiple Parts. The visualization looks like below.