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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Visual level filters not working in my report

Hi, 

 

I have a dashboard which a table Countries which depends on two measures as slicers: Continent and Currency. The first one is selected with a slicer and the second one, on a table Currency. I want the registries on the Countries table only  when a continent is selected on the slicer and a currency on the table. To do so, I have created two measures: 

 

 

continent= if(calculate(distinctcount('continent'[continent_name]),allselected('continent'[continent_name]))=1,"Y","N")
currency= if(calculate(distinctcount('currency'[currency_name]),allselected('currency'[currency_name]))=1,"Y","N")

 

 In both cases, when a continent and currency is selected, I want the countries table to be shown. But, as you can see in the screenshot, Country is returning values (BA and GE) even if currency's value is 'N'. Why is this happening? I'm struggling with this since yesterday and I'm not able to find a solution 😞 Am I using visual-level filters wrong?
problem_powerbi.png

 

Thanks for your attention and help .

1 ACCEPTED SOLUTION

Hi @Anonymous ,

Based on your description, I have created this sample table:

tb.png

Create this visual control measure, put it in the visual filter of currency table and country table, set its value as 1:

visual control =
IF (
    NOT ISFILTERED ( 'Table'[Contient] ),
    0,
    IF ( NOT ISFILTERED ( 'Table'[Currency] ), 0, 1 )
)

vc.png

When select a contient in a slicer:

r1.png

Then select a currency in the currency table:

r2.png

Attached my sample file in the below, hopes to help you.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , Not very clear but try >= and check

continent= if(calculate(distinctcount('continent'[continent_name]),allselected('continent'[continent_name]))>=1,"Y","N")
currency= if(calculate(distinctcount('currency'[currency_name]),allselected('currency'[currency_name]))>=1,"Y","N")
Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak , sorry, but this didn't solve my  issue 😞 When I choose a continent, both currency and countries table are inmediately populated, and this is not the behaviour I'd like to have. I'll try to explain clearer with an example of use:

1. The user should select a continent. Before selecting this continent, tables Currency and Country must appear empty (with no registries)

2. When the user selects a continent, the possible currencies appear, but the Country table must remain empty

3. Only when a currency is chosen in the table, the Countries will appear. 

This is the logic I'd like to  use, but apart from this, I don't understand why I'm applying  a filter but this filter doesn't seem to work. Have visual level filters a logic or hierarchy I'm ignoring?

Hi @Anonymous ,

Based on your description, I have created this sample table:

tb.png

Create this visual control measure, put it in the visual filter of currency table and country table, set its value as 1:

visual control =
IF (
    NOT ISFILTERED ( 'Table'[Contient] ),
    0,
    IF ( NOT ISFILTERED ( 'Table'[Currency] ), 0, 1 )
)

vc.png

When select a contient in a slicer:

r1.png

Then select a currency in the currency table:

r2.png

Attached my sample file in the below, hopes to help you.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.