Forum Discussion

mfarsln's avatar
mfarsln
Regular Visitor
6 years ago
Solved

Show or Hide Pivot Table Column Conditionally

Hello,   I have a pivot table with one row dimension, one column dimension (date) and two measures. What i want to do is that showing two measures if only its last date in the context.   For the ...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi mfarsln 

     

    You may download my PBIX file from here.
    Hope this helps.

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

mfarsln's avatar
mfarsln
Regular Visitor
6 years ago

Thank you so much mwegener it worked.

 

But one last thing. If i don't filter date field it works perfectly. But if i filter date, say i select 01.01.2019 and 01.02.2019, it still recognizes 01.03.2019 as last date. So it shows pbamount for both dates. pbamount should only be visible under the last date of the given context.

 

And what is the logic behind these 1 and 2? I couldn't get what those numbers represent here.

parry2k's avatar
parry2k
Super User
6 years ago

mfarsln I looked at mwegener  solution and it is very clever, you need to change this to get the lastdate based on selection, change ALL to ALLSELECTED

 

var MaxDate = CALCULATE(MAX('Table'[date]),ALLSELECTED('Table'))