relations management
2 TopicsIssues with slicer and custom shape map
I created a Choropleth map with mapshaper.org. Its a topojson. It inported into Power BI without any issues. But i am not able to use the slicer to create filters or any color in the map. I looked at the the data and found tha most of it was just comming in as a list I created an referance sheet which I thought would work for the Slicer and color and could be connected to the map data unfortuanly the I cant manage the relationship to hook them together becasue the list data will not match the table data. Is there a way to expland out the topojson so that i can match teh data or create bew veriables from the Topojson? (I have blured out the company informtation but teh feilds of area manager and State exsist in both the map and the referance sheet)663Views0likes0CommentsDatamodeling in PowerBI - Relation on different Product ID Patterns
Hello, Need some assistance with Datamodeling in PowerBI Image there are table with Product ID and Profit from different countrys. The Product ID Pattern in each table is different but contains the same number, like GB_2323GR F2323 D-2323 How could i map (create a relation) this tables with the product ID 2323 in this example and compare the profits in a report?