Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm having the following issue:
- I have created a graph that based on the filters applied, changes the total values displayed in the graph.
- I have created a variable called "BridgeYAxisMinValue" which I want to assign as the Min Value in the Y axis of the graph so that it's not starting from 0 and the visibility of the graph is better.
- The variable is working - I'm getting the right number which should be assigned to the graph y axis but it's simply not taking it into account and it's always set at 0.
- When I plug the value as a number (Instead of as a variable) on the y axis MIN field, the graph adjusts perfectly as I need it
- I have assigned the variable as a whole number/integer and it hasn´t helped.
Has anyone seen or encountered this issue? Would you have any idea of what could be causing it or any suggestion how to solve it? Any input would be highly appreciated as I've been trying to fix it in many ways and none have helped.
Thanks!
Alex
Example Below:
(The min value in the Y axis should be 257 instead of 0)
Hey @Alexvl ,
my measure looks like this:
vizAid MinValue for y-axis =
var colorsContainPink = IF( CONTAINSROW( VALUES( 'DimProduct'[ColorName] ) , "Pink" )
, 1
, 0
)
return
if( colorsContainPink = 1
, 20000000
, 200000000
)
The measure above "simulates" a dynamic Minimum value.
The below gif shows that selecting Pink adjusts the minimum value, and selecting a color that has a value assigned greater than the minimum value works as well.
But when selecting a color that is not Pink nor a color with a value greater that the Minumum value an internal rule seems to kick in.
Maybe adds some help.
Regards,
Tom
Hey @Alexvl ,
what data visualization type are you using?
Regards,
Tom
Hey @Alexvl ,
this is weird, because it seems to work on my side:
I created a simple measure and used this as the min value on the waterfall chart.
I noticed that the chart returns to 0 as a min value when the max value is smaller than the min value, this happens due to filtering.
Is this something you are encountering?
Hopefully, this provides some ideas of how to tackle your challenge.
Regards,
Tom
@TomMartens thanks for the suggestions - I started looking into it and found this:
Do you know why, even if the variable value is considering the right number (calculaton-wise), the minimum value on the graph is only the constant one assigned? Below an example of what's happening on my graph:
Here's how I'm calculating the variable, adding a 100 constant in the end for testing purposes:
Here's how the waterfall looks like, and as you can see, it only takes the 100 constant instead of the actual calculation which would give 497 (I have tried it also with values which are below the Max number in the waterfall and it still takes the constant as reference, not even 0, fx below, where the Min Value on the variable assigned to Y is 497, yet the min Y value given is only the 100 constant):
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |