CODEWITHSUNDEEP
powerbi
Jas
Jas

Reputation: 1

Power BI - Unable to breakdown data on Sub-category (city from country) level

I'm trying to show Revenue for each city, but the values keep getting summarised based on Country and show the same value for all the cities from that particular country.

These are the two tables, I have country & city name in my lookup table "Location" which has a many-to-many relationship with my data table "InternetSales"

Yet, the results I'm getting is (please see below) I want Cities to show values relevant to them and not aggregated country fig

Upvotes: 0

Views: 153

Answers (1)

mkRabbani
mkRabbani

Reputation: 16908

If you are using just pick and drop columns in the report canvas and there are appropriate relation exists in between tables, you should not faced this issue. This should be just a drag and drop with a perfect output. I have attached a sample data set with power bi output for your reference (Excel part is sample data)-

enter image description here

After adding the data source, I simply dragged 3 columns Country, city and Revenue in the table and you can see the output is city specific.

Now, if you are using custom measure, please add measure code with your question with some sample data. That would help to diagnose the issue further.

Upvotes: 1

Related Questions