Forum Discussion

puru85's avatar
puru85
Icon for Helper II rankHelper II
2 years ago
Solved

How to Configure Card Visual for selected day Value and Line Chart for selected month's Daily Values

Hi Experts, I have PBIX Report, with Three Filters: Year, Month and Day and Two Cards and Two Line Charts Visualzation.  Visual Requirements:   1) Card Visuals : Display the value for selet...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi puru85 ,

    Thank you for ryan_mayu answer , and I have other suggestions for you:
    Below is my table:

    You can create two measure:

    Measure = SELECTEDVALUE('Table'[Day])
    
    Measure 2 = 
       VAR _month = SELECTEDVALUE('Table'[Month])
       RETURN
         CALCULATE(MAX('Table'[Day]),FILTER('Table','Table'[Month] = _month))

    and click the visual interaction:

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

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