Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm struggling with selectedvalue, I setup a single value slicer to get the user input on productivity ratio.
the labor productivity is reported correctly in the report tab, but when I use the selectedvalue from the slicer for calculation, then always return blank.
my purpose is to selected productivity by user and then calcualte the man-hours needed, and eventually calcualte the cost.
a snapshot as below:
please kindly help, many thanks in advance.
Solved! Go to Solution.
Hi @Anonymous
You are using it in a calculated column, this is the cause. Calculated columns are calculated and populated when they are created and refreshed. They are not able to be changed dynamically according to users' interactive behaviors in the report. And your Labor_Productivity_Ratio Value is actually a measure with the default value blank(), so it displays blank() in the column.
To use it dynamically, you should put it in measures or visuals directly. Use measures to calcualte the man-hours and costs instead of calculated columns.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
some supplement information: I want to use the selected value back to data calculation, but always get blank, isn't the selectedvalue a global variant? or I can only use that in measure?
Hi @Anonymous
You are using it in a calculated column, this is the cause. Calculated columns are calculated and populated when they are created and refreshed. They are not able to be changed dynamically according to users' interactive behaviors in the report. And your Labor_Productivity_Ratio Value is actually a measure with the default value blank(), so it displays blank() in the column.
To use it dynamically, you should put it in measures or visuals directly. Use measures to calcualte the man-hours and costs instead of calculated columns.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |