Hide a series in a line+stacked column visual

[ViNy]

Hi,

I'm struggling to "hide" a series in a stacked column + line visual.

I have the following graph :

X axis : months

stacked colum : count of record, series = categories ( exple : a, b, c, d, e)

line : count of record (for all series)

In this configuration, the total length of the column is the same than the line.

I woudl like to hide (remove) the series with category b in the stacked columns but I would like to keep the series in the total count of records (for the line). The goal is to have a better view on all the other categories.

I would like to have something like :

Do you have any idea on how I can do that ?

For now if I hide / exclude a series, the line is moving also.

Can you help me ?

[Rushali]

Hi, 
If I have understood this correctly, one of your categories has a large volume which you need to filter out from stacks but consider in line values. 

For this you can create a separate measure for line values : something like 

line_values = CALCULATE(SUM('Table'[Value]), ALL('Table'[Category])) : This will ignore any category filters applied on the visual and consoder all categories in the subtotal by period. 

refer below:
Before: 

After: 

In here, the purple line is considering the filter on Category values whereas yellow line is the one driven by the measure. In second screenshot Category b is filtered but yellow line still counts category b.

Please accept this as solution if this helps.

[ViNy]

Hi,

Thanks a lot for your answer. In a "simple test" project it's indeed working perfectly.

After some hours of investigation it seems that in my case it doesn't work because of a combination of multiple factors :

- The 'Table' is the result of the Union of 2 other tables 

- The category is a column calculated, based on a 3d table with 

In a summary : Table1 UNION Table2 ==> Table with column 'Table'[Category] calculated with a formula to get the category from a 3d Table 'Table3' or from 'Table1' (with some conditions in a IF)

It seems that this combination of configuration (UNION / Relationship between tables / caluclation) causes the line is moving when I'm filtering on the Category.

I will continue to investigate, but if you have any wonderfull idea .... 😉

Thanks a lot,

Regards, 

[ViNy]

Hi all,

After some investigation, and deep-diving in the details of mydata, I discovered that if for a specific day, I have some data of category a, if I remove the category a in the filter, the measure doesn't count that specific day in the total.

I will try to explain with figures :

Month	Category	Value
01-Jan	a	2
01-Jan	b	6
01-Jan	c	1
02-Jan	a	3
03-Jan	a	2
03-Jan	b	3
05-Jan	d	2
01-Jan	b	5
01-Jan	b	2
03-Jan	b	2

Result with all categories :

If I remove category "a" in the visual, I receive :

When I was expecting the have the line not changed.

Can you help ?