Hide lines in stacked line chart

[corporate]

Hi everyone,

I had to create a line chart as an user asked in this post: https://community.powerbi.com/t5/Desktop/Line-Chart-With-Values-As-a/td-p/199703 and it worked. Here is my chart:

What I need to do now, is to create a filter for the Category in my chart (Age Range) that doesn't affect the values in the chart, but simply hides the lines (all other filters should work as usual).

For example, when I select Age 18-40, the chart adjusts its values and displays a single line with value 1 (100%),

But I don't want adjusted values, I need the same line of the previuos chart, as if all the other lines have been simply hidden.

Can you help me?

Thank you!

[nandukrishnavs]

@corporate - Could you share the pbix file/sample tables and existing measure logic. 

[corporate]

Hi @nandukrishnavs , unfortunately with my account I can't share the pbix file, but here is an example of my table:

Month	Target	Region	Age Range	Production
201912	Domestico	Lombardia	18 - 40	10
201912	Domestico	Lombardia	40 - 50	15
201912	Micro Business	Lombardia	18 - 40	20
202001	Domestico	Lombardia	18 - 40	5
202001	Domestico	Piemonte	18 - 40	7
202001	Micro Business	Piemonte	18 - 40	15
202001	Micro Business	Piemonte	40 - 50	20
202002	Domestico	Lombardia	18 - 40	15
202002	Domestico	Lombardia	50 - 60	20
202002	Domestico	Piemonte	40 - 50	4
202002	Micro Business	Piemonte	50 - 60	12
202002	Micro Business	Lombardia	18 - 40	16

and this is the measure I created and used as Values in line chart:

Production Age = 
DIVIDE (
    SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
    CALCULATE ( SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ), ALLSELECTED ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[AGE_RANGE] )))

 Thank you!

[nandukrishnavs · Accepted solution]

@corporate 

Try this

Production Age =
DIVIDE (
    SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
    CALCULATE (
        SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
        ALL ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[Age Range] )
    )
)

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[corporate]

It works! Thank you very much!