cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Combining 2 slicers data in a single line graph

Hello,

 

I'm trying to implement this for the last 2 days, without any luck with any the solutions found in this community.

 

I have two slicers with a sub-set of data from the same column (different types). I want to choose multiple from each slicer to be able to show this measure on a line graph for each of the chosen ones. 

 

Measure: 

FundReturn100 =
VAR Fundbase =
CALCULATE (
SUM ( AssetReturns[price] );
FILTER (
ALLSELECTED ( AssetReturns[assetdate] );
AssetReturns[assetdate]
= CALCULATE ( MIN ( AssetReturns[assetdate] ); ( ALLSELECTED ( AssetReturns ) ) )
)
)
RETURN
CALCULATE ( SUM ( AssetReturns[price] ) ) / Fundbase
* 100

 

Currently, I am able to choose multiple for both slicers, but once I choose the first from the other slicer everything disappears from the graph.

 

Thank you in advance for your help.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

@Anonymous 

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Plot-difference-between-two-rows-based-on-slicer-selection/m-p/712313#M343871

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Can you describe the problem? It is not very clear with formula.

But In case you want one with time and one without time. Then let sum for data come using the slicer on the page(if there is one) and user except to avoid date filter to get GT



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Anonymous
Not applicable

Thanks for the quick reply 🙂 And sorry for not being clear enough, but I am totally on PowerBI. 

I will try to clarify it:

- 1st slicer has the type 1 list of products; (slicing by name)

- 2nd slicer has the type 2 list of products: (slicing by name)

- The graph has the value calculated by the formula; (correctly showing the result when only one of the slicer has selections)

 

The idea is to give the user the possibility to compare N to N products of the different types in the graph.

 

I hope it was more clear 🙂

 

 

 

 

Highlighted
Anonymous
Not applicable

Maybe sharing the pbix file is easy to understand what I need to show on the graph.

PBIX

 

Best,

Highlighted
Community Support
Community Support

@Anonymous 

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Plot-difference-between-two-rows-based-on-slicer-selection/m-p/712313#M343871

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors