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 sake of clarity, let me put a basic sample of my need.

 

Here is my base table;

 

 

 

 

 

 

 

 

When i simply create the pivot table i get the output like this;

 

 

What i want to see is;

 

 

Is this achievable on PowerBI?

Any help will be appreciated. Thanks a lot.

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

8 Replies

  • 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

      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

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