cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
crobaseball
Helper II
Helper II

Slicer shows the filter but it's not applying to value.

Hi, I have a situation where my slicer is working, but it's not applying to the value.  The data relationships look like this:

crobaseball_0-1620758436952.png

So the date table is the connector between the intranet data and the other data table.  When I select the date from intranet on the slicer, it's not applying correctly to the table.  The table on the left which shows $75.2M should instead show $33.35M, the value you can see in the tooltip.  I thought it had something to do with the data relationships, but as you can see above, i've created the proper relationship with it.

crobaseball_1-1620758550957.png

 

1 ACCEPTED SOLUTION
crobaseball
Helper II
Helper II

ok, i've figured something out.  the value which is populating is limiting the period of the calculation to *only* the date which is selected instead of the previous 12 months of it.  so i somehow need to get the calculation to take the input of the slicer to be the start date of the calculation.  or something like this.

View solution in original post

3 REPLIES 3
crobaseball
Helper II
Helper II

ok, i've figured something out.  the value which is populating is limiting the period of the calculation to *only* the date which is selected instead of the previous 12 months of it.  so i somehow need to get the calculation to take the input of the slicer to be the start date of the calculation.  or something like this.

View solution in original post

dkaushik
Resolver II
Resolver II

Hi @crobaseball ,

 

I think the issue is with relationship between Date table and right side table. It should be one to many not many to one. Also, you should use Date (from Date table) in slicer.

 

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

 

Thanks,

Dheeraj

Completely agree on the relationship and i have changed it.

 

But I can't use the date table as my slicer.  It has every date, and the "Project End Date" field in the "Intranet_Data" table has a much smaller list which the user actually picks from.  Don't the relationships from the one table cascade to the other through the date table?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors