Date comparison and the percentage difference between these two dates.

[afaque03]

Hi Friends,

I am stucked in a situation I need to create a report where I have two slicer both of date. when I click on first date slicer the card should display the total amount for that very date and when I click on second slicer the second card should display the data of the date selected in second slicer.

The problem Iam facing is I need to calculate the percentage difference between the total that is being displayed in these two slicer.

My slicer 1

card 1

My slicer 2

card 2

[v-shex-msft]

Hi @afaque03,

Does these slicers use different tables as sources? If this is a case, you can try to use below formulas to show percentage.

Percent M1 =
VAR m1 =
    CALCULATE ( [Measure1], ALLSELECTED ( Table1 ) )
VAR m2 =
    CALCULATE ( [Measure2], ALLSELECTED ( Table2 ) )
RETURN
    m1
        / ( m1 + m2 )

PercentM2 =

    VAR m1 =
        CALCULATE ( [Measure1], ALLSELECTED ( Table1 ) )
    VAR m2 =
        CALCULATE ( [Measure2], ALLSELECTED ( Table2 ) )
    RETURN
        m2
            / ( m1 + m2 )

If slicers are from same table, it is impossible to use multiple slicers to get different value from same table. You need to duplicate this table and use new table to get different result.

Regards,

Xiaoxin Sheng

[afaque03]

@v-shex-msftHey the date is coming from same dataset. So my two date slicer use the same dataset date field. and Date 1 slicer does not have any interaction with date 2 slicer same as vice versa

[v-shex-msft]

Hi @afaque03,

Can you please share a pbix file to test?

>>and Date 1 slicer does not have any interaction with date 2 slicer same as vice versa

AFAIK, this operation not help to get different value from same source table.

Regards,

Xiaoxin Sheng