The line in line chart break due to filter page exclude the certain selection

[Anonymous]

Hi, 

The black line in the line chart is breaking because in the Filter on this Page I exclude Others in Network Classification. I know it is breaking because it is under Others selection. But is there any way that I can make the black line there show 100? Any idea or solution to this matter? 

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Based on your case where all platinum is 100, then an easy way to do this is to add the Y-axis constant line under Analytics.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi!

Current Table:

 

Expected Output: 

My expected output is supposed to have Platinum showing as 100. As you can see the current table, does not have Platinum in October because its Network Classification is Others. FYI Network Classifications consist of (WAN, LAN, VPN, Data Center, Others). But currently, my filter page needs to exclude Others from Network Classification. So, is there a way to show Platinum as 100 so the black line chart won’t break?

Here’s are the measure for Measure Last 6 Months:

Measure% =

DIVIDE (

    SUM ( DFD_SW_NETWORK_HISTORICAL[DurationInHours]),

    CALCULATE ( [MeasureA], ALLEXCEPT ( DFD_SW_NETWORK_HISTORICAL, DFD_SW_NETWORK_HISTORICAL[Network Classification] ) ),

    0

)

Final Measure Calc = IF(DFD_SW_NETWORK_HISTORICAL[Measure%]<>BLANK(),(100)-[Measure%])

[VahidDM]

Hi @Anonymous 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/