one column in a chart should not react to slicers

[sudhav]

I have a column chart of countries population data of 3 years (2018,2019,2020) and a slicer, if i select one country from slicer, as we know that  population values will change in visual, but here i need to apply visual filter which has to  keep 2019 year column data should be constant and remains two years 2018,2020 should change according to slicer selection, how its possible. thankyou in advance. please reply me

[v-jingzhang · Accepted solution]

Hi @sudhav 

Is this what you want? You need to create a measure like below to calculate the result based on different years. Use it in the column chart as values field. 

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Year] ) = 2019,
    CALCULATE ( SUM ( 'Table'[Population] ), ALL ( 'Table'[Country] ) ),
    SUM ( 'Table'[Population] )
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[sudhav]

Ya, it is working sir, but i need to get it in visual level filter only , not by using measure, is it possible sir??

 please let me know if it is possible?? 

Thankyou in advance

[v-jingzhang]

Hi @sudhav 

I'm afraid it is not possible to keep one column fixed without using measures. The visual level filter is applied to the whole visual. We need to use some filter functions in measures to get results that are not affected by some filters. 

Regards,

Jing

[sudhav]

ok thankyou 

[edhans]

When the users selects a slicer, it filters the data. That is why columns disappear - the measures return blanks (2019 is filtered out for example).

You can modify the measure to ignore the filter. CALCULATE([Some Measure], REMOVEFILTERS('Date'[Year])) for example.

Or, you can create a shadow date table and you use those columns in the chart but filter the actual data.