Month on month comparion

[tgvrreddy]

Hi ,

I need below loke this:

Filters i want to change dynamically.

Regards,

[v-yingjl]

Hi @tgvrreddy ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[Anonymous]

here is an example 

PBIX

[v-yingjl]

Hi @tgvrreddy ,

Currently in power bi desktop dynamic slicers are not supported, but you can try to use 'Edit interactions' to disable the corresponging interaction between slicers and tables.

Refer this document: Change how visuals interact in a Power BI report 

Sample file: Month on month comparion.pbix 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tgvrreddy , you need to have two date dimensions, both independent, or both connected to the same date. 

In place of date range take a month slicer from your date table

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

calendar :https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[tgvrreddy]

Hi,

Same Date Column:

Month 

June

july

Regards,

venkat

[amitchandak]

@tgvrreddy , I think that article is for the same date.

[tgvrreddy]

Hi ,

Same.

Regards

[amitchandak]

@tgvrreddy , Can you share sample data and sample output in table format?

Mark me @ while sharing

[amitchandak]

@tgvrreddy ,

, Try like. You need two date table, both have month year in that. Keep slicer from each one .

measure1 =
var _min = minX(allselected(Date,Date[Date]))
var _max = manX(allselected(Date,Date[Date]))
return
calculate(sum(Table[Sales]), filter(Table,Table[Date]>=_min && Table[Date]<=_max))

Use the crossfilter is Date is joined and active.

measure2 =
var _min = minX(allselected(Date1,Date1[Date]))
var _max = manX(allselected(Date1,Date1[Date]))
return
calculate(sum(Table[Sales]), filter(Table,Table[Date]>=_min && Table[Date]<=_max))
//calculate(sum(Table[Sales]), filter(Table,Table[Date]>=_min && Table[Date]<=_max), crossfilter(Table[Date],Date[Date],none))