SLICER ERROR

[Anonymous]

Hi Experts,

I am adding a slicer in my dashboard, I have only two fields MTD and YTD, but when I brining the filed in the dashboard, there is new field automatically added as Blank.

How to avoid this?

Below is the snap shots of my table and dashboard

 

Anyone Please help!

Thank you

[moizsherwani · Accepted solution]

@Anonymous This is usually a reflection that there are one or more rows in one of the table which doesn't have a corresponding entries in the other. You can 

1) choose to either have a look at the data to see if it can be fixed so entries in both tables correspond

2) if the above is not possible, you can add a page level filter and have the [selector] field be not euqal to blank

Regards,

Moiz

If this post helps, please Accept it as Solution to help other members find it.