Showing 2 cards result that filtred from diffrent slicer on the same page

[chaichatp]

For exaple, If I have a same data and I want to compare result for different date what is the best solution?

Page 1, Filter 1

Pager 2, Filter 2

Page 3, cpmpare both Filter1&2 and Card 1 and 2 result show here. 

I tried to play with sync slicer but It cannot play with each element in the page, it plays with the whole page. 

Thank you.

[v-gizhi-msft]

Hi,

Please take following steps:

1)Create two seperate date slicer table:

Date Slicer-1 = SELECTCOLUMNS('Table',"Date",'Table'[Date])
Date Slicer-2 = SELECTCOLUMNS('Table',"Date",'Table'[Date])

2)Create two measures to fetch the selected value in two slicers:

Value-1 = CALCULATE(SUM('Table'[Values]),FILTER('Table','Table'[Date]=SELECTEDVALUE('Date Slicer-1'[Date-1])))
Value-2 = CALCULATE(SUM('Table'[Values]),FILTER('Table','Table'[Date]=SELECTEDVALUE('Date Slicer-2'[Date-2])))

Choose these two measures as Card visuals, when select two different dates in above two slicers, the result shows:

Hope this can help.

Best Regards,

Giotto Zhi

[chaichatp]

I tried your way but once I chose more than 1 choice in either Slicer 1 or 2, it showed me Blank. Did that happen to you too? Thanks

[v-gizhi-msft]

Hi,

You should choose two date in two different slicers.

Here is my test pbix file:

pbix 

Sorry for any inconvenience.

Best Regards,

Giotto Zhi

[chaichatp]

Already tried your file, got same result as mine.

[v-gizhi-msft · Accepted solution]

Hi,

I am sorry i have misunderstood your requirement, please try these new measures for two card visuals:

Value-1 = CALCULATE(SUM('Table'[Values]),FILTER('Table','Table'[Date] in FILTERS('Date Slicer-1'[Date-1])))

Value-2 = CALCULATE(SUM('Table'[Values]),FILTER('Table','Table'[Date] in FILTERS('Date Slicer-2'[Date-2])))

When you choose more than one value in one slicer, the result shows:

Best Regards,

Giotto Zhi

[chaichatp]

Thank you so much, really simple and useful.

[amitchandak]

@chaichatp ,Did not get it completely. please explain with example

This seems like most nearest to current description : https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601