Dynamically show data in table when another visualisation is selected

Question

I have a pie chart showing total income based on three different platforms.

You can then break the platform down to database, so underneath the pie I have a table showing database and total income.

So when you select one platform from the pie, the table below will show all the relevant databases for that platform.

When you haven't selected a platform, the table below shows all databases.

I want the table to be blank until someone selects a platform.

Is this possible at all? I have a feeling no, but thought I would ask.

anthonytilley · Accepted Answer

you can use the hasonefilter function and then rplace with blank if not true

in the code below replace sum('Table'[amt]) with the measure you are showing in your table

measure = if(HASONEFILTER('Table'[platform]),sum('Table'[amt]),BLANK())

Forum Discussion