Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |