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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Visual dependent on filter from another visual

Dear Sirs,

 

I would like to do something in my report in PowerBI. Right now I have 2 maps shown in my report, one being a dotted map, and the other being a filled map. I would like to make the Filled map dependent on the dotted map. By this I mean that I don't want the Filled Map visual to show anything, before something has been filtered in the dotted map visual.

Is it possible to do this in Power BI, having the visual to show "You must select a zip code from the other visual" or something like that, until the user actually does so?

Thanks in advance 🙂

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @Anonymous 

 

Create a measure as below and add it to Filled Map visual filter.

Measure = IF(COUNTROWS(ALLSELECTED('Table'))<>COUNTROWS(ALL('Table')),1,0)

8.PNG9.PNG10.PNG

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @Anonymous 

 

Create a measure as below and add it to Filled Map visual filter.

Measure = IF(COUNTROWS(ALLSELECTED('Table'))<>COUNTROWS(ALL('Table')),1,0)

8.PNG9.PNG10.PNG

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Anonymous
Not applicable

Thanks @v-jayw-msft your solution did the trick. It managed to get our report to work smoother 😉

amitchandak
Super User
Super User

@Anonymous , create a measure which shows blank when the value in the other map is not filtered. use isfiltered

 

Refer:https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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