Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
HassanAshas
Helper V
Helper V

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, 

 

HassanAshas_0-1669193475693.png

 

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 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

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.

veasonfmsft_0-1669278978075.png

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

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

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.

veasonfmsft_0-1669278978075.png

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.