Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have three datasources: Category, Location, and Data.
Category has products broken down by category
Location has City and City, State
Data has Product Names, How Many Sold, City
I have a relationship between the Location (City) and the Data (City) columns... and a relationship between the Category and Data (the Category Column for both).
I have a Map visual that has the cities of clients that buy the product and I have a Donut Chart visual with the Category and Quantity Sold... I want to be able to click on a location on the map and have it adjust the Quantity for that specific location. Instead, it is adjusting the quantity of that location including the other location data as well.... I hope that makes sense.
If we sold 50% Can Beverages and 50% Bottled Beverages for all locations (17 total)... when I click on one location (Miami), it says we sold 15% Can Beverages and 0% Bottled Beverages (since it's pulling other location data)... I want it to say that Miami has 100% Can Beverages.
Sample data please (preferrably that can be copy and pasted.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg, is my data given not okay as sample data? Can it be worked with for a solution?
Thank you
is there a way I can upload a test dashboard? I thought I remember seeing someone do that before but I don't know how.
if not, here is the data:
DATA:
City | Category | Quantity | Description |
Miami | Can Bev | 20 | Diet Coke-12 24 CA |
New York City | Bottle Bev Carb | 30 | TRain Ice Orng Mango 11oz 24ca |
Denver | Bottle Bev Carb | 40 | TRain Ice Orng Mango 11oz 24ca |
Miami | Can Bev | 10 | Diet Dr. Pepper-12 24/CS |
Denver | Bottle Bev Carb | 15 | Min. Maid Apple Juice-15.2/24 |
Dallas | Bottle Bev Carb | 22 | Min. Maid Apple Juice-15.2/24 |
Miami | Can Bev | 43 | Fresca Peach-12oz/24Ca |
New York City | Bottle Bev Carb | 61 | TRain Pch Nectarine12oz 24CA |
Denver | Can Bev | 40 | Diet Sprite Zero-12 24/CS |
Dallas | Can Bev | 6 | Diet Sprite Zero-12 24/CS |
LOCATION
City | City, State |
Miami | Miami, Florida |
New York City | New York City, New York |
Denver | Denver, Colorado |
Dallas | Dallas, Texas |
CATEGORY
Category | Description |
Can Bev | Diet Coke-12 24 CA |
Can Bev | Diet Dr. Pepper-12 24/CS |
Can Bev | Diet Sprite Zero-12 24/CS |
Can Bev | Fresca Peach-12oz/24Ca |
Bottle Bev Carb | TRain Ice Orng Mango 11oz 24ca |
Bottle Bev Carb | TRain Pch Nectarine12oz 24CA |
Bottle Bev Carb | Talking Rain BlkRasp-12 24/cs |
Bottle Bev Carb | Min. Maid Apple Juice-15.2/24 |
All cities selected in first screenshot... second screenshot is only Miami, but Miami should be 100% can bev
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |