Forum Discussion
How to Filter the Table Values based upon a What-If Parameter Value
I have a Table and a What-If Parameter as shown below, What I want to do is make the Slicer interact with the Table, that is, if the Slicer value is greater than any of the Total Sales ...
Hi, Anonymous
You may need to add a new measure like:
visual filter control = IF ( SUM ( transactions[sales_amount] ) < 'Sales Amount Filter'[Sales Amount Filter Value], 1, 0 )Then put this measure to the table visual filter pane to filter data.
BTY, your paramter column "Sales Amount Filter" contains too many values, it is recommended to increase the increment appropriately.
Best Regards,
Community Support Team _ Eason
v-easonf-msft
Community Support
Community SupportHi, Anonymous
You may need to add a new measure like:
visual filter control =
IF (
SUM ( transactions[sales_amount] ) < 'Sales Amount Filter'[Sales Amount Filter Value],
1,
0
)
Then put this measure to the table visual filter pane to filter data.
BTY, your paramter column "Sales Amount Filter" contains too many values, it is recommended to increase the increment appropriately.
Best Regards,
Community Support Team _ Eason