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.

mwegener's avatar
mwegener
Most Valuable Professional
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'))

     

     

    • mfarsln's avatar
      mfarsln
      Regular Visitor
      6 years ago

      Thank you so much for your time. It works like magic when i change it to ALLSELECTED.