Forum Discussion
Dynamic chart showing multiple values from multiple slicer selection
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.
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 :)
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
4 Replies
- Ashish_MathurSuper User
Hi,
Share some data and show the expected result.
- WardWarriorNew Member
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
- Ashish_MathurSuper User
Hi,
I cannot understand your question. Someone else who does will help you.