Forum Discussion
Update values in table which are based on a measure
The value of the measure is being changed indirectly through a what-if measure. The measure is currently based off of a count which changes based on another measure that is being calculated using a what-if measure.
Hi sachal_rana
Is it possible to share some sample data, measures and the outcome expected. Please put in google drive or one drive and share the link to explore solution.
Cheers
CheenuSing
I can share some screenshots over here. I cannot share the data itself. If this is not enough, let me know and I'll find a way to send you the stuff.
Changing the slider value updates the encircled scorecards. The scorecards are shown in the table and the column chart is based off of the scorecards.
The formula for filling the table.
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.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.
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.