Today's activity report #20
Today I continued work on the development of an add-in for Excel. The main task was to convert my Python transliteration function into a native vba script and further adapt it as a custom formula. Time spent: 4h
Популярные сообщения из этого блога
Tips to increase the likelihood of correct geo-coding
What is sent to Bing Maps? The Power BI service and Power BI Desktop send Bing the geo data it needs to create the map visualization. This may include the data in the Location, Latitude, and Longitude buckets of the visual's field well. Exactly what is sent varies by map type. For maps (bubble, scatter, and dot plot maps), if latitude and longitude are provided, then no data is sent to Bing. Otherwise, any data in the Location bucket is sent to Bing. Filled maps require a field in the Location bucket; even if latitude and longitude are provided. Whatever data is in the Location, Latitude, or Longitude bucket is sent to Bing. In the example below, the field PostalCode is being used for geo-coding, so the values in the PostalCode column are sent to Bing. Data from the Size bucket is not sent to Bing. In this second example below, the field Territory is being used for geo-coding, so the values in the Territory column are sent to Bing. Data from the Legend bucket (and the Col...
Data Table Filters within Charts in Power BI
To show underlying data for a chart visualization in Power BI, follow these steps: Select the chart visual that you want to view the underlying data for. Click on the "ellipses" (...) at the top right corner of the visual to open the dropdown menu. From the dropdown menu, select "Show as a table" option. Power BI will then display a table with the underlying data for the chart visual. You can scroll through the table to view all the data. If you want to export the underlying data to a CSV or Excel file, click on the "Export data" button at the top right corner of the table. If you need to show background data related to some point at the chart, use "Show data point as a table" from chart figure context menu. The underlying data depends on selected Legend data field columns and source data table cannot be created by selecting several records from a chart.
Комментарии
Отправить комментарий