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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

i have a same problem with this,

for my case is not based on table, i try to make the data blank, its still appear, 

my table like this :

YXCurrent StatusLast MonthLast Month AMTFollow UpFollow Up AmountContractContract AmountMark
Non ODLast MonthClose27064121240449794     
Non ODFollow UpClose  2352548721800268000 
Non ODCurrentClose    35454710169387645Today
Non OD1-10 daysClose    248571105146503249Today
Non OD11-30 daysClose    191092798101839458Today
Non OD31-60 daysClose    92167890162348094Today
Non OD61-90 daysClose    146658984188426619Today
Non OD>= 91 daysClose    18385081683246834Today
1-10 daysLast MonthClose22131268731892321     
1-10 daysFollow UpClose  17027227714766623900 
1-10 daysCurrentClose    191270430176167164Today
1-10 days1-10 daysClose    53310230220455694Today
1-10 days11-30 daysClose    193824565167280973Today
1-10 days31-60 daysClose    20565889659092391Today
1-10 days61-90 daysClose    368762742430887Today
1-10 days>= 91 daysClose    99077002100167777Today
11-30 daysLast MonthClose1554737119826176     

 

when i simply pivot appear like this image in url:

Pivot  

 

i want to show only the cell with value, could you help me to solve this