Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am creating a line chart to show a trend line for company specific metrics. I have used the SWITCH function to construct the formula seem below:
Solved! Go to Solution.
@Anonymous wrote:
For example. the months of November and December do not display the line at a monthly level but if filtered down to a daily level the line magically shows up.
The SELECTEDVALUE function will return a blank if there are multiple values within the current filter context. If you're grouping at the month level, then you'll get a blank since there isn't a single value to return. You need to tell it what date you want to compare to when multiple are available. One way to do this is to use MAX instead of SELECTEDVALUE.
@Anonymous wrote:
For example. the months of November and December do not display the line at a monthly level but if filtered down to a daily level the line magically shows up.
The SELECTEDVALUE function will return a blank if there are multiple values within the current filter context. If you're grouping at the month level, then you'll get a blank since there isn't a single value to return. You need to tell it what date you want to compare to when multiple are available. One way to do this is to use MAX instead of SELECTEDVALUE.
Hi Alexis, this fixed both of my problems, thank you for the tip and insight. I will remember this for the future!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |