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.

parry2k's avatar
parry2k
Super User
6 years ago

mfarsln you can surely achieve this by measure returning blank value if date is not the last date but that totalpbamount measure will still be under each date with no value and only show values on the last date, would that work?

  • mfarsln's avatar
    mfarsln
    Regular Visitor
    6 years ago

    Hi parry2k 
    Thanks for your quick answer but the real challenge that i'm facing is to not see totalPbAmount column under other dates. 

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      mfarsln unfortunately that is not possible, you can hide the value thru measure but you cannot complete get rid of the column

      • 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.