Dynamic visual display: Unexpected removal of the filter

[cheryl-lee33]

Hi,

I hope someone can help me.  I'm working on a dashboard to display values according to the selection in other charts.  However, I can't make it work as expected.

Pic 1 shows the first chart which is used to filter the next two visuals.  It is Ok not to select any values.  

When no item selected in the first visual, the next two visuals do not display.

Now, in Pic 2, when a selection is made in the first visual, then the related values will display in the 2nd visual.  So far, the display is still as expected.

When the value is selected in the first visual, the second visual will display according to the selection in visual 1. Visual 3 still doesn't display as expected.

Now, when the 2nd visual has displayed, I selected a value.  The outcome I would like to see is for the display in visual 1 and 2 remains and also display the relevant values in visual 3. 

However, the problem is displayed as below: the selected value in visual 1 is removed, visual 2 does record that I have selected a value because it does display the values in visual 3.  Yet, visual 2 doesn't display but turn to blank.  What did I do wrong?

In order to provide the visual display, I have created two measures to identify whether any selections are made in visual 1 and visual 2.  One of the measures are displayed as below:

Local_Area_Filtered =

IF(

ISFILTERED('All details data'[Local area]),

1,

0

)

The two measures are added to the filters for visual 2 and visual 3, and they will only display the charts if the filters is 1.

Any help is much appreciated!!

Best wishes,

Cheryl

[DavisBI]

@cheryl-lee33  That's the solution in Power BI, other methods will increase the complexity. If you want Power BI to work like Tableau, you can create an idea for that.

[cheryl-lee33]

Hi @DavisBI ,

Thank you.  I will do that.

However, I would expect it works better than Tableau.  😁

[bhagyashripatil]

Hello @cheryl-lee33 ,

Please correct me, if I have inferred wrong:

Step 1) Selection of Visual 1 -> will only display Visual 2 based on filtered data.

Step 2) Selection of Visual 2 (with already Visual 1 being selected) -> will display Visual 3 basd on filtered data.

Your filter measure is right. But for Step 2, you need to check if 'Visual 1 && Visual 2' are filtered, then only display the Visual 3.

Right now i guess, you might have applied 2 different measures as visual-level filter on Visual 3.

So try creating one consolidated measure which checks if -

Visual 3 Display = IF ( ISFILTERED( 'Visual 1[Column] ) && ISFILTERED( 'Visual 2'[Column] ) , 1, 0 ).

Try passing them through single measure, because individual measures will function differently. Consolidated single measure will check if Visual 1 & Visual 2 are filtered simultaneously & then show you the Visual 3.

Let me know, if this works for you.

If I answer your question, please mark my post as solution, this will also help others.

[cheryl-lee33]

Hi @bhagyashripatil ,

Thank you for your time to share a possible solution.  I did try that before.  Yet, as @DavisBI suggested, I still need to hold on to Ctrl key for the display to work.

Best,

Cheryl

[bhagyashripatil]

Welcome @cheryl-lee33 !!

[DavisBI · Accepted solution]

Hi, @cheryl-lee33 ,

Have you try to hold on Ctrl when you select the visual 2 ? That will keep the selected value for both visual 1 and visual 2.

Mark this post as solution if this helps, thanks!

[cheryl-lee33]

Hi @DavisBI ,

Thank you.  That works, and I did not think of that.

However, if there a way to keep both filters without using extra key?  Can any other ways of designs achieve it?  I have an existing report built in Tableau.  It can work using one visual to filter another visual, and it will just display the results.

Best,

Cheryl