Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to 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
Hi,
Share some data and show the expected result.
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
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
Hi,
I cannot understand your question. Someone else who does will help you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |