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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Shameem
Regular Visitor

Customize Parameter field

Hi , I have requirment of ad hoc report when one select of value from list  , 3 columns need to be displayed in table .

 

Eg:  List (Multi Select)

List
TRx Volume
NRx Volume
NBRx Volume

 

If TRx Volume is selected, then table should display TRx Volume, Prior TRx Volume, % Change TRx .

If NRx Volume is selected, then table should display NRx Volume, Prior NRx Volume, % Change NRx.

If both are selected then 6 measures are displayed. 

Please help how ca we achive these in Power BI.

 

Thanks

 

 

1 ACCEPTED SOLUTION
ChiragGarg2512
Super User
Super User

@Shameem  Taking into consideration that TRx Volume, Prior TRx Volume, % Change TRx, NRx Volume, Prior NRx Volume, and % Change NRx are measures. Create a field parameter using these measures.

 

After this is done, go to the field parameter table and create a column with DAX

 [ NRx/PRx = Left(`Field Parameter Column Name`, 3)].  This will create a column that will have two values NRx and PRx.

 

Put that column in a slicer and on selection respective measures will be displayed. 

View solution in original post

1 REPLY 1
ChiragGarg2512
Super User
Super User

@Shameem  Taking into consideration that TRx Volume, Prior TRx Volume, % Change TRx, NRx Volume, Prior NRx Volume, and % Change NRx are measures. Create a field parameter using these measures.

 

After this is done, go to the field parameter table and create a column with DAX

 [ NRx/PRx = Left(`Field Parameter Column Name`, 3)].  This will create a column that will have two values NRx and PRx.

 

Put that column in a slicer and on selection respective measures will be displayed. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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