Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello.
Before I forget, thank you!
Question for the knowledge base.
Is there a way to modify a calculated column from input in a visualization:
This is a "rough" description of what I am trying to achieve
Edit:
Further to my question.
"Calculated columns are calculated at load and not affected by slicers and report interactions. You need a measure"
So I would need a measure such as:
Volume (new) at selected customer and selected location = volume x selected %Change
Hi @jfranco
Actually that there is a alternative workaround for your initial problem:
First of all, create a measure to store the value of increase or descrease:
For example, -50%:
INC/DES = -0.5
Then add a calculated column:
Column = 'Table'[Volume]*(1+[INC/DES])
The result is as follow:
You can modify the measure to change the value of the DES or INC.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I appreciate your reply. That is what I previously had in my model.
A table that created the 'step change'
[ Step_Change = GENERATESERIES(-.20, .20, 0.005) ]
then a slider based on a measure
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |