Filter visual and keep the right percentage

[shainis]

Hello,

I would like to filter this visual so that the parts marked in Red will not show up (hide them).

However, if I filter the visual, I get 100% on both sides:

How can I filter the visual and keep the right data?

thanks 🙂

[v-cazheng-msft]

Hi @shainis 

If you just want to remove the parts marked in Red and keep other parts in this visual. You can try the following steps.

Right click on the parts you want to remove and select Exclude, then the result will look like this:

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shainis]

Hi, it still doesn't work 😞

This is what I want to do:

Is it possible?

Thanks!

[v-cazheng-msft]

Hi @shainis 

Can you share some sample data in English without sensitive data and show me the result you want?

Best Regards,

Caiyun Zheng

[shainis]

Hi, sure.

Please see the pbix file here:

https://drive.google.com/file/d/1Bvs3NuKhUuTvGC3OKMtu7CnzgsXpG0vh/view?usp=sharing

This is what i'd like to see (just show the "yes" data):

Thanks! 🙂

[v-cazheng-msft · Accepted solution]

Hi @shainis 

You can create a Measure and then use it to create visual.

%GT Count of yes =

VAR yes =

    CALCULATE (

        COUNT ( Sheet1[yes or no] ),

        FILTER ( Sheet1, Sheet1[yes or no] = "yes" )

    )

VAR total =

    CALCULATE (

        COUNT ( Sheet1[yes or no] ),

        FILTER ( ALL ( Sheet1 ), NOT ( ISBLANK ( Sheet1[yes or no] ) ) )

    )

RETURN

    yes / total

The result looks like this:

For more details, you can refer the attached pbix file.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shainis]

This is great. Thanks!!

[Syndicate_Admin]

Hello

when I select the exclusion operation the result disappears, but the percentage changes to 100%, instead of the previous value. I want the percentage value to stay as part of all the results. our data consists of several questions and each question has two results: yes or no. there is no need to show two results because the results are complemented.

Thank you

[Syndicate_Admin]

Hello

when I select the exclusion operation the result disappears, but the percentage changes to 100%, instead of the previous value. I want the percentage value to stay as part of all the results. our data consists of several questions and each question has two results: yes or no. there is no need to show two results because the results are complemented.

Thank you

[Syndicate_Admin]

Hello

when I select the exclusion operation the result disappears, but the percentage changes to 100%, instead of the previous value. I want the percentage value to stay as part of all the results. our data consists of several questions and each question has two results: yes or no. there is no need to show two results because the results are complemented.

Thank you

[Syndicate_Admin]

Hello

when I select the exclusion operation the result disappears, but the percentage changes to 100%, instead of the previous value. I want the percentage value to stay as part of all the results. our data consists of several questions and each question has two results: yes or no. there is no need to show two results because the results are complemented.

Thank you

[stavel]

hello

when I select the exclude feature the result disappears, but the percentage changes to 100%, instead of the value before. I want the value of the percentage to stay as a part of the whole results. our data is composed of several questions and each question has two results: yes or no. there is no need to show two results because the results complement themselves.

thank you

[selimovd]

Hello @shainis ,

is that a measure in the column?

If yes can you post the formula or provide a file with the data? This would make it easier to see where the error is.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[shainis]

Hi, thanks.

It's just a simple data of True/False in Text format:

Thank you.