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
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