March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 value of any customer, then that customer should be filtered out from the table.
How do I make sure of this?
I tried to add a Visual Filter on the Total Sales Column and tried to do this, Filter out all the values where Total Sales < Slicer Value, but it also didn't work for me. As it doesn't allow me to add "Slicer Value" attribute in the Visual Filter.
You can download the related Workbook from here: https://drive.google.com/file/d/15x7m3nXdlRgHdPBxOGqrJRVYYX8hEgLp/view?usp=sharing
Edit: Why I am doing this using a What-If Parameter and not by simply adding Sales Column as Slicer, is because I want to use the value of this slicer to create additional measures. That is something I can't do with Sales Column
Solved! Go to Solution.
Hi, @HassanAshas
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
Hi, @HassanAshas
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |