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.
Hi, I've a Pie chart on my dashboard in Power BI. The Pie chart is based on the column that inlcudes duplicates. I have a card on my dashboard that shows me the number of distinct values in that column & also the total number values (no. of rows in excel). When I select "Count" the pie chart works well but when I select "Distinct Count", I expect the Pie chart to change values on only have the unique distinct in it. However, when totalling the numbers of the slices.
Hey @PRFInstitute
Try Plotting below Measure which calculated distinct count in pie chart.
MeasureUniqueCount = DISTINCTCOUNT(YourColumnName).
If it worked for you please accept this reply as solution!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |