Forum Discussion

sachal_rana's avatar
sachal_rana
Frequent Visitor
8 years ago

Update values in table which are based on a measure

My table contains two columns; one is static text field, and the other column has values based on a calculated measure. If the value of the measure changes, the table does not update and hence the co...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi sachal_rana,

So, you want your Bar visualization, column "Value" will update the data same with Line 2 - Score card

Exp: 50-60% will change 1016 to 1091   ; 60-70% will change 841 to 1085 ; and go on.....until 90-100%? But it's seem nothing else matter?

 

Hope you can share me your pbix in private box with missing some important data.

 

Regards,

ManNVSM.

sachal_rana's avatar
sachal_rana
Frequent Visitor
8 years ago

Yes. The scorecard value is supposed to be shown on the column chart in the way it is shown. A simple chart from the scorecards would look something like this.

This updates the value as scorecard value changes, but it is not something I want. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi sachal_rana,

       You make me confuse. Your first issue about "column don't change when using slicer" already solve by yourself, aren't you?

    • If yes, please update your own answer with the right fomular (using what-if,...) and choose solution. Then open a new issue for your next problem, and tag my nickname in new topic please.
    • If no, please description more the result expect. I just found your need at this moments: "Basically I want to show the custom ranges on the x-axis and the value in the scorecard on the y-axis. The values are based on a custom measure which updates based on the slider value."

    Regards,

    ManNVSM.

    • sachal_rana's avatar
      sachal_rana
      Frequent Visitor
      8 years ago

      Anonymous

      Sir, I think you're not getting my problem. I know that there is a limitation of PowerBI currently that calculated columns are not updated when the values of the measures change based on the slicer. 

      What I want to achieve is that I want this graph to update based on the scorecard values which change based on the slicer. How can I achieve that; that is the question. 

      Check out the video. This might clear it up for you. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi sachal_rana,

           Please try this:

        1. Copy "Value column" fomular, and delete this column.
        2. Create "New Measure", paste old formular in.
        3. Use new measure for your bar chart, ,try again.

        By the way, please show me the fomular of each Measure1, I wonder what happen when selected age inside it. Maybe we'll using SELECTEDVALUE.

         

        Regards,

        ManNVSM.