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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
FelipMark
Helper II
Helper II

1 Parameter With 2 Measures

Hey guys, I created a parameter to change the visualization of the measures of a table:

TEST PARAMETER = {
("Sales PY", NAMEOF('New Measures' [Sales PY]), 0),
("Sales", NAMEOF('Measures'[Sales]), 1),
("Average Ticket", NAMEOF('Measures'[Average Ticket]),2)
}

However, I want that every time I click on the filter, it returns two measurements.

Ex:
Parameter 1 = Sales + Sales Variation;
Parameter 2 = Sales amount + Amount Variation;
Parameter 3 = average ticket + Ticket Variation;

It is possible??

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi, here is a step by step article on how to do it.

You pick in parameter slicer one option but get several columns displayed at a time. Let me know if any questions 

https://www.linkedin.com/pulse/field-parameters-case-measure-groups-olga-dontsova/?trackingId=z1tmg1...

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

1 REPLY 1
olgad
Super User
Super User

Hi, here is a step by step article on how to do it.

You pick in parameter slicer one option but get several columns displayed at a time. Let me know if any questions 

https://www.linkedin.com/pulse/field-parameters-case-measure-groups-olga-dontsova/?trackingId=z1tmg1...

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.