Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

SP

Issue with Slicer not filtering for a particular value ONLY!! Please Help!!

Submitted by on ‎04-10-2018 05:42 PM

Hi All,

 

I am facing a weird error while filtering a table with all data from a month slicer.

The slicer is working for all months except for April value "01-Apr-18".The table turns blank for April.

 

I have my relations connected (1:M) and working well for all other months.Also, checked the datatype and made it consistent for all the relations across datasets.

 

Even i checked my using the same filter for months to slice the table containing only that same month column then also it is blank for April. This is really weird and making me  stressed as i need to release this dashboard but cant really rectify this issue.

 

Any help is really appreciated. Thanks in advance!!

Capture.PNG

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎04-12-2018 06:59 PM

Hi @SP,

 

Please add a table visual into the report, drag Report Month, Monthly Sales By Rep columns to the table visual. When you select the April value "01-Apr-18" in the slicer visual, please check if Monthly Sales By Rep has value for this month in the table visual. 

 

As there is a relationship between these two tables, please use the field which is used for building a relationship with Report month column to filter Monthly Sales By Rep. 

 

Best Regards,
Qiuyun Yu 

Idea Statuses