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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
fionamann_
Frequent 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.

 

AccountMonth 1Month 2Month 3Month 4
A38281239
B15102217
C59456142

 

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

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

Hello @fionamann_ ,

 

For your question, I have created the following table.

vjialongymsft_0-1701766047319.png

 

 

Then you can set the field parameters

vjialongymsft_1-1701766047322.png

 

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

vjialongymsft_2-1701766070291.png

 

 

 

Best Regards,

Jayleny

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

View solution in original post

3 REPLIES 3
v-jialongy-msft
Community Support
Community Support

Hello @fionamann_ ,

 

For your question, I have created the following table.

vjialongymsft_0-1701766047319.png

 

 

Then you can set the field parameters

vjialongymsft_1-1701766047322.png

 

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

vjialongymsft_2-1701766070291.png

 

 

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.