cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hpinho77 Frequent Visitor
Frequent Visitor

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
Community Support Team
Community Support Team

Re: Combining 2 slicers data in a single line graph

@hpinho77 

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Plot-difference-between-two-rows-based-on-slicer-selection/...

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
Super User IV
Super User IV

Re: Combining 2 slicers data in a single line graph

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

Highlighted
hpinho77 Frequent Visitor
Frequent Visitor

Re: Combining 2 slicers data in a single line graph

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 🙂

 

 

 

 

hpinho77 Frequent Visitor
Frequent Visitor

Re: Combining 2 slicers data in a single line graph

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

PBIX

 

Best,

Community Support Team
Community Support Team

Re: Combining 2 slicers data in a single line graph

@hpinho77 

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Plot-difference-between-two-rows-based-on-slicer-selection/...

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors