Forum Discussion

shaheenmomin's avatar
shaheenmomin
Advocate II
9 years ago

Dynamic Charts

Is it possible to change data with in a chart based on slicer value selection. For example below we can change the percentage for each period and this will be shown in the chart. so dynamically chang...
Need Help
shaheenmomin's avatar
shaheenmomin
Advocate II
9 years ago

Sorry but it seems that power bi cant handle dynamic charts specially with dynamic measure. I created a slicer which has percentages from -100 to 100 and when I select one , i get the selected value saved in a custom measure from 

selectedValue =
IF (
    ISFILTERED ( FILTERTABLE[Value] ) && HASONEVALUE ( FILTERTABLE[Value] ),
    LASTNONBLANK ( FILTERTABLE[Value], 0 ),
    "a default value"
)

now when I create a custom column which multiply selected value * Revenue(which I got from querying sql database), it doesn't works, when I put a hard coded value like (5 * revenue) then it works. As per my experience, based on what user selects in the slicer if calculated in a custom column in order to show on a chart seems not possible. Please help me with this if any one has already done it.

  • shaheenmomin's avatar
    shaheenmomin
    Advocate II
    9 years ago

    Dont go on a exact coding for getting values .. instead of default value I have used 1 so that it can be multiplied with revenue with no effect on actual revenue.