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

Thank you for this. For the values do they need to be hardcoded or can they be dynamic?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AMitchell 

     

    Do you mean that values are calculated? Is it a measure? Then you can try to change the two formulas to the following.

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

     

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

     

    I hope this helps.

     

    If you need further help, could you provide some example data and the logic of calculating values so that I can better reproduce your scenario? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Please remove any sensitive data in advance.

     

    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.