How to remove other dates in visual?

[Tumbleweed]

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!

[v-stephen-msft · Accepted 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.

[v-stephen-msft · Accepted solution]

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

[v-stephen-msft · Accepted 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.

[Tumbleweed]

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) + 0

Once I removed 0, the visual started working correctly.

Thanks again!

[Tumbleweed]

https://drive.google.com/file/d/1oWwuhx39G3AWGDdcirThGxakuh6prk4t/view?usp=sharing

[Tumbleweed]

I think there is relationship between slicer and visual:

[vojtechsima]

 @Tumbleweed 
Please share a copyable dataset for me to test out.

[vojtechsima]

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.

[Tumbleweed]

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?

PREVIEW

[vojtechsima]

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

[Tumbleweed]

I just posted the link above. I woud appreciate any help with fixing the visual.

[Tumbleweed]

I just posted the link above. I woud appreciate any help with fixing the visual.