Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
I have a scatter chart where I would like to define a constant line on the X-Axis using a parameter slicer
I would like to make the max value of the parameter equal to the maximum value of the X-Axis. If I do this simply by saying MAX(Column_XAxis), I lose the context of the filters applied to the chart.
How do I keep my Max value based on the filters applied to the chart?
Thank you
Solved! Go to Solution.
I used this as my solution if anyone looks at this in future.
https://www.youtube.com/watch?v=AZAL-QPn5Zc
@2NV_DB , That should work if you use constant line using fx option
or try
maxx(allselected(Table), Table[Value])
I used this as my solution if anyone looks at this in future.
https://www.youtube.com/watch?v=AZAL-QPn5Zc
Hi @amitchandak ,
I am changing the position of the constant line based on the slicer. For example, if my x axis is sales, and I do Max(Sales[Netsales]) I would get 1,500,000. However, on my chart I have selected various filters such that the displayed data has a maximum of 300,000. As such, I would the largest value I can select on my slicer to be 300,000, and not 1,500,000. This should change dynamically based on the filters selected.
I hope this is clearer.
Thank you!
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |