How to hide all values in a table that is filtered by another table

[Anonymous]

Hi all,

I have something that I think should be easy enough to do but I'm having a bit of a problem getting it work like I would hope.

I have a table visualization, we'll call it "Summary". It looks like this:

<Division>|<Team>|<Person>|Month|Day|Task|Sum of completed tasks

AAA|ABC Team|Jack|April|10|Do stuff|12

AAA|ABC Team|Jill|April|11|Do other stuff|1

When I click on the "Task" entries, I want a second table visual to populate with the individual tasks and how long they took. I can do that part, actually, with filters. And it works. When I click, for example, on "do stuff" i get entries in Table2 showing the details of said task.

HOWEVER, when no task is selected, I want that table to be blank (or ideally, invisible entirely). At the moment, for whatever reason, if I don't have a task selected, it's showing me ALL tasks in my data source, until I limit it down to a specific one.

Hopefully that makes sense. I can try to show more examples if needed.

Thank you!

Josh

[Anonymous]

This may be what i'm looking for (or at least a way to make it behave the way I want). Will experiment and report back: https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

[vojtechsima]

Hi, @Anonymous 
Something like this:

Measure like this and inside the visual as filter:

FilterLimit = IF(ISCROSSFILTERED('Table 1'[Service Name (Unique)]), 1, 0)

[vojtechsima]

@Anonymous 
Technically, if you play with the colours and stuff you can completely hide it:

[Anonymous]

@vojtechsima this may be pointing me in the right direction, but...in my case, my initial table visualization and the details visualization come from the same underlying data source table, and the ISCROSSFILTERED function appears to require separate tables (not visualizations) to function correctly (looking at the docs, anyway).

When I use the formula you show above, it isn't filtering my results, and my interpretation of said docs is that it's not doing so because both sets of data are from the same source table. Is that correct or am I missing something?

I do *not* have "cross filters" turned on for the page, I'm doing this by "Editing Interactions" and telling the details table that it is filtered by the base table. So, I may be doing that wrong, too.

Thank you for your help!

[vojtechsima]

Hi, @Anonymous 
Can you try putting there "ISFILTERED" instead of crossfiltered and lemme know if that works?

[Anonymous]

@vojtechsima tried that with no luck. Also tried (just to see what would happen) adding my field to the "Cross-report" filter section, with no change.

[Anonymous]

Maybe IF(HASONEVALUE (Summary[Task]),1,0) ?

[Anonymous]

Unfortunately, that does not change the behavior.

[vojtechsima · Accepted solution]

Hello, @Anonymous ,
Are you using the measure in the Filter Pane?
I mean, I took your provided dataset and recreate the measure and it just works:

I am providing sample pbix file you can use to play around.

[Anonymous]

Hi @vojtechsima you are correct! I was making Stupid Human Trick kind of mistakes in using your examples above. I apologize for the added confusion. Your solution DOES indeed work.

The link I provided is the "how to make this all look smooth" example. I think I've probably found a few ways to improve upon it, with what you suggested. Thank you for your help!