Forum Discussion

rmaddala's avatar
rmaddala
New Member
7 years ago
Solved

Need help Card visual

Hi   I have a requirement to show Card visual with Current_Year and Prior_Year value one below other   And I need to compare values and change color to Red/Green/Amber   Normally, a card visual...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi rmaddala ,

    Based on my research, you could try to use "Ultimate KPI CARD" custom visual to solve your problem:

    Sample data:

    Create below measures:

    Current year = CALCULATE(SUM(Table2[Value]),FILTER('Table2',YEAR('Table2'[Date])=YEAR(NOW())))
    Last year = CALCULATE(SUM(Table2[Value]),FILTER('Table2',YEAR('Table2'[Date])=YEAR(NOW())-1))
    Difference = ([Current year]-[Last year])*1.1

    Result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi rmaddala ,

Based on my research, you could try to use "Ultimate KPI CARD" custom visual to solve your problem:

Sample data:

Create below measures:

Current year = CALCULATE(SUM(Table2[Value]),FILTER('Table2',YEAR('Table2'[Date])=YEAR(NOW())))
Last year = CALCULATE(SUM(Table2[Value]),FILTER('Table2',YEAR('Table2'[Date])=YEAR(NOW())-1))
Difference = ([Current year]-[Last year])*1.1

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He