Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
techtina
Frequent Visitor

Showing values in one dataset missing from another dataset on pie chart

I have 3 datasets.

  • Dataset A --> this is the “master” excel file with SenderName, SenderID, ShipmentNo. This represents total shipments.
  • Dataset B --> this is a sql server query which I merged with Dataset A to pull ShipmentNo’s in the database included in Dataset A. Not all shipments in Dataset A are included in Dataset B.
  • Organization table --> this is a database table which is connected to the SenderId in Dataset A and SenderOrganizationID in Dataset B

The purpose of this pie chart is to show the proportion of distinct ShipmentNo’s in Dataset A that is not included in Dataset B. In the pie chart below, there are 40 total shipments under that specific organization, and 39 of those shipments are missing, meaning not included in Dataset B. Therefore, the red part should cover most of the pie chart, not split in half like below.

The values in the pie chart at the moment are a result of measures I had initially created:

 

Total Shipments  = DISTINCTCOUNT('Dataset A'[ShipmentNo])

Shipmentcount = DISTINCTCOUNT(Milestones[ShipmentNo])

Missing Shipments = [Total Shipments] - [Shipmentcount]

 

 pie_chart.PNG

I realized that merely finding the difference in the distinct count between both datasets will not solve my problem. However, I am stuck because I’m also unable to create a direct relationship between Dataset A & B. If anyone can help me find a workaround, it would be greatly appreciated!

relationship between tables.png

6 REPLIES 6
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @techtina,

 

Could you share a dummy pbix file which can reproduce the issue, so that we can better assist on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploadingSmiley Happy

 

Regards

Hi @v-ljerr-msft

 

I greatly appreciate your help since I am still stuck on this. To simplify it, I am basically trying to show the measure "CountFalse" as a proportion of the "Total Shipments" measure in the pie chart. In the pbix file, I'm trying to get the pie chart to read: "39 out of the 40 distinct shipments are false under organization TOL." Therefore, the red portion should cover 97.5% of the pie when sliced by TOL. 

 

pie.PNG

 

 

Here is the link to the file on one drive: https://1drv.ms/u/s!Ao2_nHZB2FWRbxLiiIbwp0iax9w

@techtina

 

Hi

 

Put in Legend Your Matched Column

 

And In Values Total Shipment

 

 

Regards

 

Victor

 

 




Lima - Peru

Hi @Vvelarde,

 

That won't work in my case because I need the whole pie to represent the total, and "false" to show the portion of the total it makes up. The total is a distinct count, and so is the the matched column. 

@techtina

 

Hi, Do you want to see like this?

 

Wjhol.png




Lima - Peru

@Vvelarde@v-ljerr-msft

Nope. That pie chart reads out "out of 40 total distinct shipments for TOL, 39 are false and 1 is true." 

 

I want the pie chart to disregard "true." It should read "Out of 40 total distinct shipments for TOL, 39 of them are false." So 39 should be the majority of the pie. 

 

Thanks for your help! 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.