Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have 3 datasets.
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]
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!
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 uploading.
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.
Here is the link to the file on one drive: https://1drv.ms/u/s!Ao2_nHZB2FWRbxLiiIbwp0iax9w
Hi
Put in Legend Your Matched Column
And In Values Total Shipment
Regards
Victor
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.
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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
97 | |
58 | |
45 | |
42 |