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.

     

     

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

create this measure and use it in place of the current one

 

CALCULATE ( 
           [Diff % LY],
           KEEPFILTERS(Date[year] = 2025)
)

 

Date[year] might have to be changed based on the name of your tables/columns

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI