Forum Discussion
How to dynamically exclude data from bar chart
- 1 year ago
Here is the solution:
1) make a table, "Exclusion Range", the data column can be generated by generateseries(-20000,20000,5)
2) bring the table of Exclusion Range to a slicer, slicer setting should be "Betweeen"
3) Create a measure, Value Bigger Than = max('Exclusion Range[Value]')
4) create a second measure, Value Smaller Than = min('Exclusion Range[Value]')
5) Place these two measures into the measures used in Parameter field, for example,
Net MBOE = CALCULATE(SUM('OTSD Reconciliation - Working'[NetMBOE]), FILTER('OTSD Reconciliation - Working', sum('OTSD Reconciliation - Working'[NetMBOE])> [valueBigger Than] || sum('OTSD Reconciliation - Working'[NetMBOE])<[Value Smaller Than]))
6) Reset the slicer of exclusion range, which will exclude those range from bar chart.
Thanks everybody!
Paul
Here is the solution:
1) make a table, "Exclusion Range", the data column can be generated by generateseries(-20000,20000,5)
2) bring the table of Exclusion Range to a slicer, slicer setting should be "Betweeen"
3) Create a measure, Value Bigger Than = max('Exclusion Range[Value]')
4) create a second measure, Value Smaller Than = min('Exclusion Range[Value]')
5) Place these two measures into the measures used in Parameter field, for example,
Net MBOE = CALCULATE(SUM('OTSD Reconciliation - Working'[NetMBOE]), FILTER('OTSD Reconciliation - Working', sum('OTSD Reconciliation - Working'[NetMBOE])> [valueBigger Than] || sum('OTSD Reconciliation - Working'[NetMBOE])<[Value Smaller Than]))
6) Reset the slicer of exclusion range, which will exclude those range from bar chart.
Thanks everybody!
Paul