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.
Solved! Go to Solution.
Hi,
According to your description, i create a sample to test:
Then please try to create a column to show new type:
NewType = IF(CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Type]))/COUNTROWS('Table')<=0.1,"Other",'Table'[Type])
Choose pie chart, it shows:
Then create a new page, choose [Type] as Pie chart, and apply a filter to it, it shows:
Turn on DrillThrough function:
When you choose 'Other' type in the first page, you can drill through to see its details:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
According to your description, i create a sample to test:
Then please try to create a column to show new type:
NewType = IF(CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Type]))/COUNTROWS('Table')<=0.1,"Other",'Table'[Type])
Choose pie chart, it shows:
Then create a new page, choose [Type] as Pie chart, and apply a filter to it, it shows:
Turn on DrillThrough function:
When you choose 'Other' type in the first page, you can drill through to see its details:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
v-gizhi-msft - Great solution. Thanks your help along with PBIX file. You are the best!
Refer :https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning
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 |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |