Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've got a report with a line chart, I wish add to my report a reference line on demand: in particular I'd like to have a filter which specifies some reference lines (max - min - mean, etc.) so that when user clicks one of these the relative reference line is displayed into the chart, is it possible?
Thanks in advance for any hint!
Solved! Go to Solution.
First create a table with a column with Max, Min , Average ...Use this to show a slicer to select the calculate formula of the line.
Next, create a measure to calc accord to slicer selected.
LineCalc = IF ( VALUES ( Table1[Value] ) <> BLANK (), IF ( HASONEVALUE ( Table2[LineType] ), SWITCH ( VALUES ( Table2[LineType] ), "Max", CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1 ) ), "Min", CALCULATE ( MIN ( Table1[Value] ), ALLSELECTED ( Table1 ) ), "Average", CALCULATE ( AVERAGE ( Table1[Value] ),ALLSELECTED ( Table1 ) ) ) ), BLANK () )
Vvelarde’s solution should be correct. You can also try to use the Min/Max/Average Line in analytics pane as below.
Best Regards,
Herbert
@v-haibl-msft unfortunatelly reference lines can't be shown/hidden on demand with this solution
First create a table with a column with Max, Min , Average ...Use this to show a slicer to select the calculate formula of the line.
Next, create a measure to calc accord to slicer selected.
LineCalc = IF ( VALUES ( Table1[Value] ) <> BLANK (), IF ( HASONEVALUE ( Table2[LineType] ), SWITCH ( VALUES ( Table2[LineType] ), "Max", CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1 ) ), "Min", CALCULATE ( MIN ( Table1[Value] ), ALLSELECTED ( Table1 ) ), "Average", CALCULATE ( AVERAGE ( Table1[Value] ),ALLSELECTED ( Table1 ) ) ) ), BLANK () )
Hi @Vvelarde,
thanks for your suggestion, only twoclarification:
How are related the slicer selection and the LineCalc measure? Does Table2[LineType] in switch statement represent the current selection in the slicer?
How can I add the LineCalc measure to my chart?
Here my chart without reference lines
I should add LineCalc measure to "Valori" field (Spot Series Values is the measure which draws the chart lines), but if I drag and drop LineCalc measure to "Valori" field it overwrites Spot Series Values
Thanks a lot!
How are related the slicer selection and the LineCalc measure? Does Table2[LineType] in switch statement represent the current selection in the slicer?
Yes. able2[LineType] represent the current selection in slicer. The slicer is the column of tha table with the line types.
How can I add the LineCalc measure to my chart?
If you have a legend this doesnt' work. When you use a legenf only Works with 1 line.
Not to my knowledge.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |