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.

     

     

sivarajan21's avatar
sivarajan21
Icon for Post Prodigy rankPost Prodigy
1 year ago

Hi grasa ,

 

Method 1: Conditional Formatting with Blank Values

Modify your "Diff % LY" measure to return BLANK() for 2024:

Diff % LY = 
IF(
    YEAR(MAX('YourTable'[Date])) = 2024,
    BLANK(),
    [Your existing Diff % LY calculation]
)

If the above doesn't work, then please follow below:

Method 2: Using SELECTEDVALUE with Year Filter

If you're using a year slicer or filter, you can modify the measure:

Diff % LY = 
IF(
    SELECTEDVALUE('YourTable'[Jahr]) = 2024,
    BLANK(),
    [Your existing Diff % LY calculation]
)

Please try the above and let me know if you still face the issue

 

Best Regards,

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

Hi sivarajan21 ,

Thank you very much for your reply.

Unfortunately both versions didnĀ“t work, I still see the empty column for 2024.

 

Method 1:

    

 

Method 2:

I think the problem really is the matrix visual, as mentioned by v-sdhruv in the previous post. 

But thanks again for all the help.