Forum Discussion

AMitchell's avatar
AMitchell
Frequent Visitor
1 year ago

Date Selection

Hi all   I have data encompassing 4 different dates which i need to be able to compare. The only slicer option that seems to allow this is this one  Is there a way to just show my relevant d...
Need Help
AMitchell's avatar
AMitchell
Frequent Visitor
1 year ago

This was really helpful but i'm not quite getting what i need. What I would really like is for the top slicer to contriol the monetary card below and the second slicer to select a date for the comparison percentage card. Do you know if this is possible in PowerBi? 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AMitchell 

     

    Thanks for the reply from freginier .

     

    If I understand correctly, you want the slicer above to affect the card on the left, and then compare it to the value of the date selected in the slicer below, presented in the card on the right, right?

     

    If so, the following test is for your reference:

     

    My sample:

     

     

    Create two calculated tables as slicers.

     

     

    You can change the slicer style to “Vertical list”.

     

    Create two measures as follow

    sum = CALCULATE(SUM('Table'[values]), FILTER('Table', [Date] = SELECTEDVALUE(Slicer2[Date])))

     

     

    Measure = 
VAR _sum = CALCULATE(SUM('Table'[values]), FILTER('Table', [Date] = SELECTEDVALUE(Slicer1[Date])))
RETURN
DIVIDE(_sum, [sum])

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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