Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Syndicate_Admin
Administrator
Administrator

Hide data without values with Dynamic Graph Filters

Hello my friends, there is some way to hide the data that do not correspond to this country for example I have filtered Argentina using the dynamic filtering of the graph, I would like to hide the data that are in green and that do not correspond to the country, in order to save space at the time of showing.

*(Dynamic filter I mean to use the filters integrated in the graphs I am not using data segmentation)

Alexgamb20_0-1643574810732.png

1 ACCEPTED SOLUTION

Hi @Syndicate_Admin 

 

In order to get those to disappear, you can use Edit Interactions.  If you Edit Interactions between the two visuals, you will only be left with the one bar on the other chart (like that in your screenshots).

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

9 REPLIES 9
TheoC
Super User
Super User

Hi @Syndicate_Admin 

 

Have you tried using Edit Interactions and switch the interaction to Filter Out the other visuals?

TheoC_0-1643596003217.png

Then click on the visual you want filtered and ensure the filter is shaded as per below:

TheoC_1-1643596045560.png

Hope this helps 🙂

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Interactions wouldn't serve me xq that's just at the graphics level.. What I want is to filter all but that in certain graphs the data that does not have values are hidden.

Hi @Syndicate_Admin - Alexgamb20

 

Unfortunately, I am not understanding the request. Are you wanting to use the Filter pane on the respective visual as a way of filtering out Blank values?  If this is the case, can you drag the field onto the Filters pane, deselect Blank and achieve what you are after?  I assume it is not this, however.

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Normally I have the graph like that.

Alexgamb20_0-1643598558590.png

when I click in a month, it highlights the values of the other graphics, some with a darker color and others with a lower color. as shown in the following graph.

Alexgamb20_2-1643598789347.png

But when I filter other graphs there are bars that appear with a lighter color, I want those to disappear, because simply that country has a single process, only one shows value is correct but I want to hide the other bars.

Alexgamb20_1-1643598639131.png

Hi @Syndicate_Admin 

 

In order to get those to disappear, you can use Edit Interactions.  If you Edit Interactions between the two visuals, you will only be left with the one bar on the other chart (like that in your screenshots).

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

NOOOOOOOOOOOOOOOOOOOOOOOOo I WAS MISAPPLYING YOUR ANSWER AND I JUST UNDERSTOOD IT THANK YOU THANK YOU SOLVED THE PROBLEM FOR ME. : D YOU SHOULD BE AT NASA.

Hi @Syndicate_Admin, please make sure to mark as solved so that other members can search the solution if they come to the same problem.


Thanks again and all the best.

 

Theo 🙂

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

@Syndicate_Admin hahaha! Definitely not NASA - I think I would cause many problems for them LOL!  I am glad that it provided a solution 🙂  

 

All the best and stay safe my friend!


Theo 🙂

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

@Syndicate_Admin 

 

The Edit Interactions is at the page level.  You can establish the interactions to operate across all visuals / charts that exist on the page, not just at the graph level.  You just need to apply it to all visuals / charts.

Edit Interactions.gif

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.