Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Power bi Solution-
Calculated Columns with Dynamic/User-input Selections-
Note – this solution might not applicable to all places where a dynamic/user-input is needed.
Problem Statement—It is a common knowledge that we create Calculated measures and user-input can be used in it .
However if you want to create a calculated column and change the values of that column wrt to user- input or filter selection by users, Then column can’t work like this.
In short a calculated column can’t work on selected values().
Comment- Some might say that what is the need you can create this is calculated measure as well , but keep in mind that measure will only come in the values and if you put that in columns the whole view of the report will change.
Solution-
A work around can be applied to this situation.
Example Scenario –
User selection on View type – Sap View/ Treasury view
Calculated Column = if ( selected value(View type) = “Sap View” , “USD”, else if (selected value = treasure view , “local currency”)
In above scenario is it not possible to create a column.
Follow the below steps –
Meaning View type has 2 selection values Sap view and treasury view and with selection of sap view you need value of quote rate for sap in your field parameter and so on ,
Provide these selection values in the newly added column of field parameter – Sap View/ Treasury view
Only Challenge remains is how to connect this fields parameter with your original selection for View type
You functionality is achieved.
Download the PBIX from here
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |