Forum Discussion
Parameter as filter and visual not working
Hello All,
Please help. It's a simple 2x2 chart i need, and coule filters:
Each dot is an item
X is value score (has 3 elements, and each element weighted differently but sum to 100%) = ( Item 1 Score X Parameter input )
Y is value score (has 4 elements, and each element weighted differently but sum to 100%) = ( Item 1 Score X Parameter input )
The chart on the left is Measure, score does change based on the parameter changed, but the dot is not showing in the chart, nor can i use the as filter ( i want to filter out the score thats >= 10 for both X and Y) ; the chart on the right is Calcuated column, it does show on the chart, and it does allows me to filter, but it doesnt change based on the Parameter Input.
- Anonymous4 years ago
Hi chutli ,
I found that you are using the calculated colulmn. As far as I know, a calculated column is static, it won't dynamicly be changed by the filter of slicers. You could try to use measures instead of calculated columns.
What is the difference between Power BI calculated columns and measures? - TrueCue.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Hi chutli ,
I found that you are using the calculated colulmn. As far as I know, a calculated column is static, it won't dynamicly be changed by the filter of slicers. You could try to use measures instead of calculated columns.
What is the difference between Power BI calculated columns and measures? - TrueCue.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.