Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
Solved! Go to Solution.
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)
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.
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)
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.
Thanks @v-jayw-msft your solution did the trick. It managed to get our report to work smoother 😉
@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/
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |