Barchart Made With Calculated Measure Not Interacting With Table

[syd154]

Hi Power BI Community,

I've been trying to search for an answer to my current problem and have not found a solution, thus I'm posting it here seeking help.

Problem:

I'm seeking the best solution to have a bar chart built using different calculated measures to interact with a table. I have the below dashboard which rely on one table. It is a table with names of organizations with attributes(for this post I will only refer to the organization "name" and the attribute "website").

The barchart above is created using calculated measures so that i can show the count of records for each company that has a blank attribute (i.e. blank website). The template for the calculated measure formula used is:

Blank Website = COUNTROWS(FILTER('Company Records','Company Records'[website] = BLANK()))

The goal that I am trying to achieve is ideally to be able to click on the bar of missing website on the barchart, and have that bar chart filter/ slice the values on the table below to show the records with blank websites. An alternative solution is to perhaps create a custom slicer which I am unsure of the best way to create that.

I am most grateful of your help!