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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
darcee
New Member

Filtering Map Visual based on info in a table visual which is filtered using the top N filter

 
1 ACCEPTED SOLUTION

Well... I continued playing around, and of course right after posting for help (having spent a good 30 minutes seeking a solution) I figured out a solution! 😂

I just had to filter the "market" field int he map visual by top N just like I did the table... so obvious now!

darcee_0-1704965514418.png

 

View solution in original post

2 REPLIES 2
darcee
New Member

For some reason I am unable to edit the body in the post, so I'll add details here...

 

I'm working on a repoort which contains a dimension table of markets (countries) and a fact table with sales information. I have a table visual with countries filtered by top 5 using the Top N filter function. There are also fiscal year filters on the page. I'm trying to create a map visual that responds dynamically to highlight the top 5 countries based on fiscal year selection (as the table does). 

 

I tried creating a measure to use as a filter for the map, such as the below, but that's not working...

Top5CountriesNetSalesDynamic =
CALCULATE(
    [Net Sales],
    TOPN(
        5,
        ALL(dim_market[Market]),
        CALCULATE([Net Sales], fiscal_year[fiscal_year] = VALUES(fiscal_year[fy_desc])),
        DESC
    )
)

 

darcee_0-1704964889731.png

 

Well... I continued playing around, and of course right after posting for help (having spent a good 30 minutes seeking a solution) I figured out a solution! 😂

I just had to filter the "market" field int he map visual by top N just like I did the table... so obvious now!

darcee_0-1704965514418.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors