Forum Discussion

grasa's avatar
grasa
Icon for Helper I rankHelper I
1 year ago
Solved

Show Diff PY just once

Dear all,   I would like to show a qty vs. previous year qty comparison. Therefore I already created a measure which calculates the % diff to last year. Do you have any idea how I could remove the ...
Need Help
  • grasa's avatar
    grasa
    1 year ago

    v-sdhruv Many thanks for your feedback! 

    Now I put a white square over the text to hide the headline "Diff % LY" for 2024. Probably not the best solution but I couldn´t find another one 😉 . 

    Thanks again for all the help.

     

     

jaineshp's avatar
jaineshp
Icon for Memorable Member rankMemorable Member
1 year ago

Hey grasa,

Create a new version of your Diff % LY measure with conditional logic

 

Diff % LY Modified =
IF(
YEAR(MAX('DateTable'[Date])) = 2024,
BLANK(),
[Your existing Diff % LY measure]
)

 

Fixed? ✓ Mark it • Share it • Help others!


Best Regards,
Jainesh Poojara | Power BI Developer