The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 🙂
Solved! Go to 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.
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.
Hi, it still doesn't work 😞
This is what I want to do:
Is it possible?
Thanks!
Hi @shainis
Can you share some sample data in English without sensitive data and show me the result you want?
Best Regards,
Caiyun Zheng
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! 🙂
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.
This is great. Thanks!!
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
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
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
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
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
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.
Hi, thanks.
It's just a simple data of True/False in Text format:
Thank you.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
139 | |
110 | |
107 | |
76 | |
62 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |