One slicer interacting with multiple numeric columns

[fionamann_]

Hi,

I have a table in Power BI which has seperate columns with the number of transactions that happened in each month.

Account	Month 1	Month 2	Month 3	Month 4
A	38	28	12	39
B	15	10	22	17
C	59	45	61	42

I want to be able to add one slicer to the report which let's me see all accounts where there is a minimum of 10 transactions in each month i.e., there would need to be at least 10 trasnaction in each month. Is there a way to do this, currently I have a slicer for each month and I need to update all 4 of them to the desired result.

Thanks in advance

[Anonymous · Accepted solution]

Hello @fionamann_ ,

For your question, I have created the following table.

Then you can set the field parameters

Then write the following measures and apply it to your table

Measure = SWITCH(TRUE(),
ISFILTERED('Parameter'[Parameter Fields])=FALSE(),1,
SELECTEDVALUE('Parameter'[Parameter Order])= 0 && MAX('Table'[Month1])>10,1,
SELECTEDVALUE('Parameter'[Parameter Order])= 1 && MAX('Table'[Month2])>10,1,
SELECTEDVALUE('Parameter'[Parameter Order])= 2 && MAX('Table'[Month3])>10,1,
SELECTEDVALUE('Parameter'[Parameter Order])= 3 && MAX('Table'[Month4])>10,1,
0)

This is the result

^{Best Regards,}

^Jayleny

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[fionamann_]

Thank you for this response! I'm new to parameters so didn't think to try this

[Anonymous]

Look into Field Parameters:
Dynamic filtering with Field parameters in Power BI! - Data Mozart (data-mozart.com)

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn