Slicer month measures and last 12 months sales.

[chalam87]

Hi,

I am new to Power BI, could you please suggest me how can we achieve the below requeriment.

I have month and year slicer like Dec 2017, Nov 2017,Oct 2017, Sep 2017........Jan 2017, when ever select any one of the month then show that month "Total Sales", "Total Quantity" and show last 12 months Sales on bar chart.

Regards,

Chalam.

[Anonymous]

Please any one can share dax query for thos problem .I want to dispaly previous 12 months sales including slicer month

[v-shex-msft]

Hi @chalam87,

You can refer to below link to know how to write a measure as the dynamic visual title:

Dynamic Titles

Regards,

Xiaoxin Sheng

[Phil_Seamark]

Hi @chalam87

One approach is to not have a relationship between the date table you use as your slicer and your Retail Sales table.

This way you can create a calculated measure that you can use as s filter on your visual that allows a date range that is not filtered by the slicer table.

I've uploaded a cut down version here for you to have a look at

https://1drv.ms/u/s!AtDlC2rep7a-oD0hNMo_6maOMyVY

[chalam87]

Hi Phil_Seamark,

Thank you for quick reply.

I tried your solution it's working fine when we have only view measures based on date column in Retail Sales but in same table i have two more dates(shipdate and receiptdate).

If calculate based on shipdate and receiptdate, the result is giving wrong.

Could you please suggest me how can manage more than one date.

Regards,

Chalam.

[v-shex-msft · Accepted solution]

Hi @chalam87,

I'd like to suggest you create new table to expand the date range between these date columns and build relationships to original table. After these steps, you can use new table's date as parameter to calculate.

Reference link:

Loans in different currencies/periods - calculate current value each loan - last month currency rate...

Regards,

XIaoxin Sheng

[Anonymous]

Show last 12 months sales including slicer month and tables have a relationship in Power BI.How it can do with relationship.