hide lines in graph without affecting the total percentage

[Denismc]

Hi,

I have an arrears line chart and its a percentage of the total book each month, i only want to show 3 arrears categories againset the total and allow for filter of areas. if I filter the lines out the percentages change. Is there a way to hide an line so percentages don't change 

Thanks

[Anonymous · Accepted solution]

Hi @Denismc ,

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the new measure to calculate the percentage and hide one line.

Measure = 
VAR categ = SELECTEDVALUE('Table test'[Category])
VAR da = CALCULATE(SUM('Table test'[Arrears]), ALLEXCEPT('Table test', 'Table test'[Category], 'Table test'[Date]))
VAR arrea = CALCULATE(SUM('Table test'[Arrears]), ALLEXCEPT('Table test', 'Table test'[Category]))
RETURN
IF(categ = "ab", BLANK(), DIVIDE(da, arrea)
)

3.Drag the field and measure into the line chart visual.

4.The result is shown below.

Best Regards,

Wisdom Wu

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

[Denismc]

Thanks for the responce, while that is a solution, ideally having a hide option on a chart would fix the issue on any element to be used. Have a great weekend.