Forum Discussion

tyan's avatar
tyan
Helper II
4 years ago
Solved

Pie Chart and switch function

Hi thank you for helping me. I new to BI and try to create some easy graphic to see the whole picture.    So I would like to create a pie chart that show how many stores that their rating are less ...
Need Help
Show and Tell
  • VahidDM's avatar
    VahidDM
    4 years ago

    HI tyan 

     

    Use this code to add a new calculated column to your table:

    Cat. = 
SWITCH (
    TRUE (),
    [Rating] < 0.2, "<20%",
    [Rating] > 0.2
        && [Rating] <= 0.25, "20%~25%",
    [Rating] > 0.25
        && [Rating] <= 0.5, "25%~50%",
    [Rating] > 0.5
        && [Rating] <= 0.75, "50%~75%",
    [Rating] > 0.75
        && [Rating] <= 1, "75%~100%"
)

     

    Then use that to create a pie chart:

     

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

     

rbriga's avatar
rbriga
Impactful Individual
4 years ago

As a note on VahidDM 's solution, 

The way SWITCH() resolves the data, you can do away with the first part of the && condition- SWITCH() already confirmed it on the last calculation step:

=SWITCH (
    TRUE (),
    	Table1[Rank] < 0.2, "<20%",
   	Table1[Rank] <= 0.25, "20%~25%",
  	 Table1[Rank] <= 0.5, "25%~50%",
	Table1[Rank] <= 0.75, "50%~75%",
	 Table1[Rank] <= 1, "75%~100%"
)

You may also wish to add a first clause to deal with null values- if you have any.