Power BI KPI Visualization Ideas - MTD,DTD,YTD

[SriGaG]

Dear Experts,

I am new to poweBI. can anyone tell me Power BI KPI visualization ideas to represent MTD,DTD and YTD values? The KPI card must be really interactive. They need to be created under  YTD, MTD and DTD level for  Sales,cost of sales, production and profit.

Thanking you in advance. 

[amitchandak]

@SriGaG , You can use date table and time intellignece 

This month = CALCULATE([Net],DATESMTD(ENDOFMONTH('Date'[Date])))
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

This Year Sales = CALCULATE(SUM(Sales[Sales Amount]),previousyear('Date'[Date],1,Year), "7/31")

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[SriGaG]

Hello

Thank you for your quick reply. I am looking for some dashboard KPI visualization ideas. That need to be really interactive and informative to the customers.  The kpis need to be created under  YTD, MTD and DTD level for  Sales,cost of sales, production and profit.

[amitchandak]

@SriGaG , Field parameters can help. https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

or can you elaborate the need

[SriGaG]

Hello. Tanks. But im looking for Dashboard KPI ideas,. I mean visualization ideas, can you give me links to sample interative dashboards that are hving nice KPI cards and stuff?