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 I forgot to Mention .. I need this feature in Power BI.. 

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago

    The technique will work in Power BI too.

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