Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

V-lianl-msft
Community Support
‎10-23-2020 01:52 AM

Alternative for Max line in the Analytics pane

Issue Description:
When adding a Max line in the Analytics pane for the Line chart, the Max line does not disappear when measure returns BLANK.   

  

Environment: 

Power BI Desktop Version: 2.85.963.0 64-bit (September 2020)  

   

Repro Steps: 

  

Sample data:

V-lianl-msft_1-1603442228770.png

 

Add a Line chart and a Slicer  

V-lianl-msft_2-1603442251412.png

 

V-lianl-msft_3-1603442274058.png

V-lianl-msft_4-1603442286320.png

 

Change the selected range in the slicer, the Max Line is still exist.

 

GetImage (3).png

 

Workaround:

Instead of using Max line in the Analytics pane, drag measure below to plot it.

 

Measure 2 =

MAXX ( ALLSELECTED ( 'Table'[Column1] ), [Measure] )

GetImage (4).png

 

 

Before

GetImage (5).png

 

After

GetImage (6).png

 

 

See attached file for details.

 

 

Author: Sam Zha

Reviewer: Kerry & Ula

analytics.pbix
0