Forum Discussion

ohohbudi's avatar
ohohbudi
Frequent Visitor
9 years ago
Solved

How to group data

Hello, I want to ask how to group the data. I have discount product data which contains discount number from 0 - 150 like this :  And i want to make a pie chart that only will be divided into ...
Need Help
Show and Tell
Tutorial Requests
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi ohohbudi,

    >>I want to create a pie chart divided into 2 categories : '0%' and 'Not 0% Discount'. Then, if I click the the pie chart on 'Not 0% Discount', there will be a table that will show all the discounts percentage > 0% list (1%, 3%, 5%, 7%, etc)

     

    For your requriement, I try to reproduce and get expected result.

    I create sample table.



    I create a calculated column to  get percentage ([Diskon Product]/[Total Product]). Then use IF...ELSE function to judge if the percentage is 0.

    Percentage = Table2[Diskon]/CALCULATE(SUM(Table2[Diskon]),ALL(Table2))

    Tag = IF(Table2[Percentage]=0,"0%","Not 0% Discount")

     

     



    Create a Pie Chart and Table visual. Please view the following screenshot. The green part show the count of 0 percents, and the back part shows the not 0 percents.



    When you click the 0%, it will list the 0 %. Otherwise, it will returns other results.


    Please let me know  if you have any issue.

    Best Regards,
    Angelia


MalS's avatar
MalS
Resolver III
9 years ago

Click on your discount field in the field list on the right, then on the ribbon click on Modeling > New Group. Set group type to List, then click on the 0 and click the Group button. That's your 0% group. There should also be an 'Other' group that will automatically contain everything else (which you can rename if you like). Click OK and the group will show up as a new field that you can add to your pie chart, etc.

 

If you add a table with the discount field it will list all of the discounts (make sure you set it to Don't Summarize), then when you click on the pie chart it will automatically filter the table the way you want.