Forum Discussion
fionamann_
2 years agoFrequent Visitor
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...
- Anonymous2 years ago
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.
Anonymous
2 years agoNot applicable
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_2 years agoFrequent Visitor
Thank you for this response! I'm new to parameters so didn't think to try this