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 changing graph/chart based on user selection. Need this in Power BI.

Really appreciate all your help in advance.. 

Need Help

6 Replies

      • 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.