Forum Discussion

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

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.

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

Most Valuable Professional

6 years ago

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
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
  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
    Regular Visitor
    6 years ago
    Thank you so much for your time. It works like magic when i change it to ALLSELECTED.

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 :

Y	X	Current Status	Last Month	Last Month AMT	Follow Up	Follow Up Amount	Contract	Contract Amount	Mark
Non OD	Last Month	Close	27064121	240449794
Non OD	Follow Up	Close			235254872	18002680	0	0
Non OD	Current	Close					35454710	169387645	Today
Non OD	1-10 days	Close					248571105	146503249	Today
Non OD	11-30 days	Close					191092798	101839458	Today
Non OD	31-60 days	Close					92167890	162348094	Today
Non OD	61-90 days	Close					146658984	188426619	Today
Non OD	>= 91 days	Close					183850816	83246834	Today
1-10 days	Last Month	Close	221312687	31892321
1-10 days	Follow Up	Close			170272277	147666239	0	0
1-10 days	Current	Close					191270430	176167164	Today
1-10 days	1-10 days	Close					53310230	220455694	Today
1-10 days	11-30 days	Close					193824565	167280973	Today
1-10 days	31-60 days	Close					205658896	59092391	Today
1-10 days	61-90 days	Close					3687627	42430887	Today
1-10 days	>= 91 days	Close					99077002	100167777	Today
11-30 days	Last Month	Close	155473711	9826176

when i simply pivot appear like this image in url:

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