Dynamic chart showing multiple values from multiple slicer selection

[WardWarrior]

Hi,

I have a table:

Table1=

Date | Attribute | Value

I have 18 attributes, i am trying to have a dynamic chart that can show the sum of multiple attributes selected in the slicer.

I have found an article that gets me close, however when selecting multiple values on the slicer it sums the outcomes together instead of showing each individually.

https://www.fourmoo.com/2017/08/08/power-bi-how-disconnected-slicers-can-enrich-transform-your-analy...

1) created a disconnected slicer with the 18 attributes.

2) created measure to sum values in table 1. 'Test' = SUMX(Table1, Values)

3) Created a measure as below, however my result is a summed total of more than one measure instead of two seperate values.

Distance (Selected) =
// This Variable is looking for the selected value from the Disconnected Slicer
// If nothing is selected then display "No Activity Selected"
VAR ActivitySelected = SELECTEDVALUE(Activity[Activity],"No Activity Selected")
// Now using an IF statement, we can then pass through the required values.
RETURN
// If nothing has been selected then return the entire distance
IF(ActivitySelected = "No Activity Selected",
        [Distance],
// Else if a value is selected the pass that value to the calculate below
CALCULATE(
            [Distance],
            Activities[Activity Type] =
 ActivitySelected
 )
)

 Any help is much appreciated 🙂

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[WardWarrior]

Thanks Ashish,

The expected result is to have a dynamic graph like the below examples (line graph etc) that is linked to the slicer.

The slicer allows one or more sets of data to be presented, i am having difficulty getting the 2nd set of data to display.

This is what my data looks like;

Date	Attribute	Value
01/08/2017	StockPrice	48.72
01/05/2017	StockPrice	49.81
01/02/2017	StockPrice	59.70
01/11/2016	StockPrice	66.68
01/08/2017	Debt To Equity	40.91
01/05/2017	Debt To Equity	38.26
01/02/2017	Debt To Equity	31.75
01/11/2016	Debt To Equity	36.70

Thanks

[v-qiuyu-msft · Accepted solution]

Hi @WardWarrior,

Based on your description, you want to select multiple values in a slicer simultaneously, right?

You can use “slicer” visual and select multiple values to filter line chart, you can download attached pbix file to have a look. 

If above result doesn't meet your requirement, please clarify desired results based on sample data. 

Best Regards,
Qiuyun Yu 

[Ashish_Mathur]

Hi,

I cannot understand your question.  Someone else who does will help you.