Forum Discussion

chutli's avatar
chutli
Frequent Visitor
4 years ago
Solved

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

 

  • Anonymous's avatar
    Anonymous
    4 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

  • Anonymous's avatar
    Anonymous
    Not 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.