Forum Discussion
One slicer interacting with multiple numeric columns
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
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.
3 Replies
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.
Thank you for this response! I'm new to parameters so didn't think to try this
