Two date slicer for two kpi card of same column.

[sahubibhuti45]

I have a calender table and a main table.

I want two kpi cards of one holding "outstanding amount" with a date slicer and where as in other kpi card having same "Outstanding amount" but a different date slicer , after that i want to calculate the difference between the two values of the kpi cards.

Is it possible?

[v-zhengdxu-msft · Accepted solution]

Hi @sahubibhuti45 

If you don't want to copy the calender table.

Maybe you can try this:

First of all, I create a set of sample data:

Then create a measure:

MEASURE = 
VAR _maxdata =
    MAX ( 'date'[date] )
VAR _mindata =
    MIN ( 'date'[date] )
RETURN
    CALCULATE ( SELECTEDVALUE ( sales[sales] ), 'date'[date] = _maxdata )
        - CALCULATE ( SELECTEDVALUE ( sales[sales] ), 'date'[date] = _mindata )

Then create a slicer with the style of between:

Then you can choose two value(max and min) with the slicer.

The result is as follow:

Best Regards

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

[dsptchr68]

Create a copy of the calendar table, duplicate the relationship between tables and use the copy for the second slicer. 

[sahubibhuti45]

Thanks, I have tried creating two different tables and tried this and was able to get the solution.