search

bhavesh-jadav / Advance-Card

Advance Card Visual for Power BI
http://bhaveshjadav.in/powerbi/advancecard/
GNU General Public License v3.0
25 stars 12 forks source link

Is there any way to show conditional formatting using another column itself in the data? #18

Closed harkrish1 closed 6 years ago

harkrish1 commented 6 years ago

Eg. I want to show current year plan cost in comparison with last year plan cost.

bhavesh-jadav commented 6 years ago

If you want to compare current year plan cost with last year plan cost, then create measure with following logic(e.g.). If current year plan cost > last year plan cost then return 1 else return 0. Put this new measure in Condition field and set condition for values 1 and 0.

harkrish1 commented 6 years ago

That’s great. Thanks!

On Thu, Sep 20, 2018 at 2:14 PM Bhavesh Jadav notifications@github.com wrote:

If you want to compare current year plan cost with last year plan cost, then create measure with following logic(e.g.). If current year plan cost > last year plan cost then return 1 else return 0. Put this new measure in Condition field and set condition for values 1 and 0.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/bhavesh-jadav/Advance-Card/issues/18#issuecomment-423281844, or mute the thread https://github.com/notifications/unsubscribe-auth/AX4SQEvpwJyHnK8IJuw_Lz8HP5QTPwmQks5uc9r1gaJpZM4Wyppp .