Bars not displaying on Stacked column chart

[raghukumarch]

Hi,

Could you please help in resolving the issue. One of our dashboard is using 'Stacked column chart' visual which suddenly not displaying Bars on visual. The dashboard is having Date slicer from 1st of Feb 2020 to till date. If I don't make Date selection, the bars on the visual are not displaying from the 1st of June (last 3 months). If I make date selection the bars are displaying data for the last 3 months. 

The issue is if I don't make any filter selection on date the dashboard is not displaying data for last 3 months. I have attached screenshots of the issue.

[raghukumarch]

Hi,

Could you please help in resolving the issue. One of our dashboard is using 'Stacked column chart' visual which suddenly not displaying Bars on visual. The dashboard is having Date slicer from 1st of Feb 2020 to till date. If I don't make Date selection, the bars on the visual are not displaying from the 1st of June (last 3 months). If I make date selection the bars are displaying data for the last 3 months. 

The issue is if I don't make any filter selection on date the dashboard is not displaying data for last 3 months. I have attached screenshots of the issue.

[raghukumarch]

Hi @v-henryk-mstf Henry,

Thanks for responding to my post. The data is displaying perfectly if I change the visual to other visual. for example table visual. there are no filters applied on this visual, also checked removing the other files but still the bars are not displaying. I think there could be some other reason. Due to the confidentiality, I couldn't provide the data model for this.  Please let me know if any other thoughts.

Thanks

Raghu

[v-henryk-mstf]

Hi @raghukumarch ,

No further tests can be done at this time. Have you tried to use other visuals to perform the same operation. Will this happen? Please provide a clear screenshot, I will explore further.

Looking forward to your reply.

Best Regards,
Henry

[raghukumarch]

Hi Henry,

I tried with table visual. the table visual is showing data without any issue. please see the below screenshot.

Thanks

Raghu

[v-henryk-mstf]

Hi @raghukumarch ,

According to your description, the problem may be caused by the filtering conditions in the Filter. I did a test, the reference is as follows.

Create a measure, if the selected date is within the slicer range, it will be 1, and then add it to the flier filter.

M = 
var a = SELECTEDVALUE('Table'[Date])
var max_data = MAX('Table'[Date])
var min_data = MIN('Table'[Date])
return IF(a<=max_data && a>=min_data,1,0)

When the slice date does not contain the value of the last three months, the corresponding column will not be displayed in the clustered column visual.

You have to check whether it is the impression caused by the additional filter conditions. If there are still problems, please provide the relevant data model (delete sensitive information), I will answer you as soon as possible. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.