Forum Discussion
How to remove other dates in visual?
Hi community,
I would appreciate any ideas on how to show only the latest date Apr 2 and remove other dates from the the stacked column visual.
Thank you!
Hi Tumbleweed ,
You could try to create a visual-level measure. Then set as follows, show items when the value is 1.
Measure = IF(SUM('Table'[Value])>0,1)Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Tumbleweed ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
11 Replies
Hi, Tumbleweed ,
You can either use a slicer and select only a single value or in the Filter pane, you can filter just the one date you want.Thank you, vojtechsima!
1. When I use slicer for any single date it shows other dates on visual.
2. When I select only a single value on the Filter pane, it shows the only date I need. But when I use slicer to go to previous dates, the visual is blank.
I need to have a single value on a visual and be able to come to previous dates with a single date shown. Is there any way to fix it?
Tumbleweed
If you need to dynamically see the dates, you gotta use slicer.
Could you please share a sample data, it the slicer doesn't work, the chart and the slicer aren't connected properly (there is no relationship between them).
I think there is relationship between slicer and visual:
Tumbleweed
Please share a copyable dataset for me to test out.
Hi Tumbleweed ,
You could try to create a visual-level measure. Then set as follows, show items when the value is 1.
Measure = IF(SUM('Table'[Value])>0,1)Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear Stephen,
Thank you very much for providing a solution! It does solve stacked column visual problem. I have found alternative solution: the value I was using was a measure that was ending with 0 to avoid showing 'Blank' in a slicer.
All Hours =VAR all_hours =SUMX(VALUES(table[org]),SUMX(VALUES(table[position]),SUMX(VALUES(table[employee]),CALCULATE(MAX(table[Total Hours Sum])))))RETURN IF (all_hours = 0, BLANK(), all_hours) + 0Once I removed 0, the visual started working correctly.Thanks again!
Hi Tumbleweed ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
