Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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
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
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.
I think there is relationship between slicer and visual:
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 just posted the link above. I woud appreciate any help with fixing the visual.
I just posted the link above. I woud appreciate any help with fixing the visual.