Forum Discussion
Map visual query
I apologize for any confusion in my previous response. You are correct, setting an assumption or criteria for what Power BI considers "successfully displayed" based on specific filter conditions may not accurately reflect what Power BI has truly understood or successfully mapped.
Power BI doesn't have an inherent capability to automatically detect what it has successfully read or understood on a map visual. It relies on the data provided and the mappings created by the user. Therefore, it's not possible for Power BI to independently determine which postcodes it has successfully displayed without some form of user-defined criteria or assumptions.
If you want Power BI to automatically determine which postcodes it successfully displays on a map, it would require advanced natural language processing (NLP) or image recognition capabilities, which are not native to Power BI. Such capabilities would involve complex AI algorithms and machine learning models to interpret the visual elements on the map, which typically falls outside the scope of Power BI's capabilities.
To achieve what you're looking for, you might consider exploring custom AI solutions that are capable of interpreting visual elements on a map. These solutions would require integration with Power BI and potentially custom development work to provide the desired functionality.
Please sahre in detail your issue and also share your data file if possible
Thank you for your response here.
I have done something similar currently to give an indication of how many postcodes should be seen on the map visual. I am interested to know if there is a more intuitive way of achieving this -- for pbi to essentially tell me how many postcodes it is able to read and present back in the map visual.
Power BI doesn't have a built-in feature to directly count how many unique values are being displayed on a map visual, especially if some of your postcodes are not being displayed due to invalid or missing data. However, you can still achieve this indirectly with some additional steps:
1. **Create a New Table for Displayed Postcodes:**
Create a new table in Power BI that contains only the unique postcodes that are successfully displayed on the map visual. You can use the `SUMMARIZE` or `VALUES` function to create this table. Let's call this table "DisplayedPostcodes."```DAX
DisplayedPostcodes = VALUES('YourTable'[Postcode])
```Replace 'YourTable' and '[Postcode]' with your actual table and column names.
2. **Create a Measure for Count of Displayed Postcodes:**
Create a DAX measure to count the number of postcodes in the "DisplayedPostcodes" table. This measure will give you the count of unique postcodes that are successfully displayed on the map.```DAX
CountOfDisplayedPostcodes = COUNTROWS('DisplayedPostcodes')
```3. **Display the Count in a Card Visual:**
Add the "CountOfDisplayedPostcodes" measure to your report as a card visual. This card visual will display the count of postcodes that are successfully displayed on the map.With this approach, you'll have a clear indication of how many unique postcodes are being displayed on the map visual. Whenever you filter or adjust your map visual, the count in the card visual will automatically update to reflect the current displayed postcodes.
This method allows you to indirectly track the number of postcodes displayed on the map visual without having a built-in feature in Power BI to directly count them.
Thank you
Just to clarify, in step 1 you have said 'Create a new table in Power BI that contains only the unique postcodes that are successfully displayed on the map visual.'
Am I correct in thinking I need to set the criteria/assumption of what PBI has read/understood and successfully mapped on the visual?
I had hoped there would be a way PBI can tell me what it has successfully read/understood instead on me setting the assumption of what I think should be readable (or matching back to ONS data on UK postcodes)
I apologize for any confusion in my previous response. You are correct, setting an assumption or criteria for what Power BI considers "successfully displayed" based on specific filter conditions may not accurately reflect what Power BI has truly understood or successfully mapped.
Power BI doesn't have an inherent capability to automatically detect what it has successfully read or understood on a map visual. It relies on the data provided and the mappings created by the user. Therefore, it's not possible for Power BI to independently determine which postcodes it has successfully displayed without some form of user-defined criteria or assumptions.
If you want Power BI to automatically determine which postcodes it successfully displays on a map, it would require advanced natural language processing (NLP) or image recognition capabilities, which are not native to Power BI. Such capabilities would involve complex AI algorithms and machine learning models to interpret the visual elements on the map, which typically falls outside the scope of Power BI's capabilities.
To achieve what you're looking for, you might consider exploring custom AI solutions that are capable of interpreting visual elements on a map. These solutions would require integration with Power BI and potentially custom development work to provide the desired functionality.
Please sahre in detail your issue and also share your data file if possible