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
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |