Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
@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.
@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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |