Forum Discussion
Dynamic banding in Stacked Column Chart via user input threshold values as comma-separated list
Hi SanketMendhe
Unless you can write back to the sourc (using Translytical Taskflows with a Fabric capacity or a third-party service) users can't simply enter an arbitrary value and expect that value to be used directly in visuals.
Also, measures don't have row context, so they can't be used as a legend. A common workaround is to use a disconnected table that the measures can reference. It is possible, but the logic can get pretty complex.
x
The example below demonstrates one way to achieve this.
Please see the attached sample pbix.
Super UserI am not sure if wen can do this by inputting the data. Maybe we can select or choose the data to set up the scope. could you pls provide some sample data and expected output
I have added the sample data format along with the approaches that have been considered in the original post. Please check and let me know if there are any alternative architectural patterns or workarounds that can achieve this functionality.