Filter on just one column of column chart

[hollyse]

On column chart, is there a way to have filters on just a specific column? I'm adding 3 columns, active, updated 5+ Days ago, and Open 30+ Days. I want them to be independent of each other, unless there is a better way i can show which of the active ones are also 30+ Days old and/or haven't been updated for 5+Days...it seems as if when i change settings of one column though, it is also messing with one of the other columns...

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solution ryan_mayu  offered, and i want to offer some more infotmation for user to refer to.

hello @hollyse , you can refer to the following sample.

Sample data 

1.Unpivot the data to the following.

2.Create the following tables, there are no relationships among the tables.

True/Fales table

Type table

Then create the following measure.

MEASURE =
IF (
    ISFILTERED ( 'Type'[Attribute] ) && ISFILTERED ( 'True/False'[Value] ),
    IF (
        SELECTEDVALUE ( 'Table'[Attribute] ) IN VALUES ( 'Type'[Attribute] ),
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER (
                'Table',
                'Table'[Attribute]
                    IN VALUES ( 'Type'[Attribute] )
                        && 'Table'[Value] IN VALUES ( 'True/False'[Value] )
            )
        ),
        CALCULATE ( COUNTROWS ( 'Table' ) )
    ),
    CALCULATE ( COUNTROWS ( 'Table' ) )
)

Then put the following field to a chart visual

Then  put the columns of true/false table and type table to the visual filter of the chart visual.

Output

Best Regards!

Yolo Zhu

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

[ryan_mayu]

could you pls provide some sample data and expected output?

[hollyse]

I have 3 columns. 

1 All Active

2 Active and Opened 30+ Days

3 Active and Updated 5+ Days Ago

When i change the filter on one, like on the 2nd one to Opened 30+ Days=True, then it seems to mess with the other columns.

Now in the above just the ones Active and Opened 30+ Days are showing. (And Updated 5+ Days ago shows all because i didn't add the filter yet to=True)

[ryan_mayu]

maybe you need to use the filter in the DAX, not the visual filter. Visual filter has the higher priority, so that will affect on the whole visual. 

Please provide some sample data (excel file or pbix file or paste the data in the reply) and the expected output based on the sample data.