Forum Discussion
Slicers Not Filtering Data Corrrectly
I'm working a report where i am pulling data from multiple tables to build a pipline for our sales. I'm pulling our quote activity, open orders and invoices together to show where we are for the year. Then connecting to a couple of other tables to define what is being sold. Below is my data model. When I'm slicing the data using the accont owner table, everything matches perfectly. When I'm slicing the data using the product table, it only filters down the Invoices. The open orders and quotes do not match up.
I've tried cleaning and trimming the part number fields from all the tables to make sure there aren't any spaces at the beginning and the end, but it is still not working. Any other ideas?
4 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
he reason of this behaviour was a Measure I used in my Pivots, which returned an error in Office 2016, but not in Office 365. Turns out, there was slight change of the DAX-Formula logic between the two Office versions. Once I found a way the DAX-Formula worked in both versions, the Data Slicers worked like expected. The DAX-Formula which caused the error in my case was: =IF([PERFORMANCE]>=0;[PERFORMANCE];"") Since the field "[PERFORMANCE]" was a number, and my IF-Formula could return either a number or a string, Office 2016 complained about data-type mismatch (Office 365 doesn't seem to bother). Therefore I changed to formula to: =IF([PERFORMANCE]>=0;[PERFORMANCE];BLANK())
Admin
