Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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..
Sorry I forgot to Mention .. I need this feature in Power BI..
Study DAX basics before going ahead, especially the evaluation context.
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.
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.
The technique will work in Power BI too.
Yes, check out my blog article here https://powerpivotpro.com/2014/10/5-interactive-chart-techniques-come-together/
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |