Forum Discussion
Donut Chart / pie chart
I resolved it.
Created two measures, one which give value for 5 products and other which gives value for rest products and added it to the donut chart.
Hi Anonymous
Sorry I misread your question.
What you can do is:
- Create the donut chart
- Since the donut chart is sorted descending, on your keyboard, hit and hold Ctrl. Select the top 5 products in the donut chart (in this case the top 5 that takes up the most space).
- Once all 5 are selected, right click on it, and click Group.
Once you've done that, it will group the top 5 as one category, and the others as another category.
I dont think that is the solution.
This is because the top 5 products may change based on the inventory values, and if you are grouping on specific products that gives the wrong value on the donut chart
I resolved it.
Created two measures, one which give value for 5 products and other which gives value for rest products and added it to the donut chart.
I resolved it.
Created two measures, one which give value for 5 products and other which gives value for rest products and added it to the donut chart.